XML element
I have following code snippet in pro *c. I'm Constructing XML element and passing to SP using Clob data type.
When compling pro *c i'm getting following error for xmlelement key word mentioned below
SELECT xmlelement("Id",
*.........1*
PLS-S-00201, identifier 'XMLELEMENT' must be declared
Error at line 203, test.pc
SELECT xmlelement("Id",
*.........1*
PLS-S-00000, SQL Statement ignored
EXEC SQL EXECUTE
declare
l_clob_xml_msg CLOB;
purge_dt DATE DEFAULT SYSDATE;
barcode_in CHAR(20) := 'TEST';
item_no CHAR(8) := '133444';
type_c CHAR(1) := 'C';
BEGIN
SELECT xmlelement("Id",
xmlelement("barCode", trim(barcode_in)),
xmlelement("item", item_no),
xmlelement("typeC", type_c),
xmlelement("purDate", purge_dt )).getclobVal()
INTO l_clob_xml_msg
FROM dual;
test_msg_sp(l_clob_xml_msg );
END;
END-EXEC;
Please let me know pro *c wont support xmlelement tag if i have embedded pl/sql block.
Thanks,
kannan