<wbi:appData>
<wbi:content wbi:name="1st_status">
<wbi:value xsi:type="xsd:string">Success</wbi:value>
</wbi:content>
</wbi:appData>this xml is in a table which has a column in the form of CLOB type.
I wanted to find if "wbi:value" tag exists in this xml or not ?
I tried using existsnode but in sql developer it is saying an error as to declare existsnode.
This is how it is ....
CREATE TRIGGER Tab_a
BEFORE INSERT
FOR EACH ROW
declare xml_a xmltype;
begin
xml_a:=xmltype(:new.value);
--here i have to check if "wbi:value" exists in the xml clob and then -
---insert function
end;
