error when select xmltype

From: mic0355 <mic0355_at_hotmail-dot-com.no-spam.invalid>
Date: Fri, 18 Nov 2005 02:11:40 -0600
Message-ID: <F8SdnfppePchEeDeRVn_vA@giganews.com>

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. Received on Fri Nov 18 2005 - 02:11:40 CST