Re: error when select xmltype

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 ... Received on Fri Nov 18 2005 - 03:53:08 CST