Re: error when select xmltype

In article <1132307588.347498.21700_at_g44g2000cwa.googlegroups.com>, stephen O'D says...
>
> mic0355 wrote:
> > what's wrong in the following pl/sql code?
> > DECLARE
> > va VARCHAR2(10);
> > vb VRACHAR2(10);
> > BEGIN
> > va := 'CA';
> > select '1' into :vb from tmptable p
> > where p.criteria.existsnode('/MSG[Type=va]') = 1;
> > END;
> > :
> > I got sql error "1403" when running the above sql. Then i tried to
> > replace va by "CA" (ie. select 1 into :a from tmptable p where
> > p.criteria.existsnode('/MSG[Type="CA"]') = 1; ) and could get the
> > expected result without any sql error.
>
> Remove the colon before vb and it should work:
>
> select '1' into vb from tmptable ...
>
>

Looks like he needs to do this instead:

..
..
 where p.criteria.existsnode('/MSG[Type="'||va||'"]') = 1; ..
..

va is the variable containing the string 'CA'

Or I could be completely misreading the problem.

-- 

jeremy