Re: error when select xmltype

> Jeremywrote:

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[/quote:8c8d7d3291]

thanks for your help....
I have tried this before. But still doesn't work (got error 1403)