Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XML element

user601042Aug 27 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2010
Added on Aug 27 2010
0 comments
822 views