This discussion is archived
3 Replies Latest reply: Jul 30, 2013 2:31 AM by odie_63 RSS

Not able to pass input to XMLType datatype.

936666 Newbie
Currently Being Moderated

hi,

 

CREATE TABLE xml_data_test(xml_data XMLTYPE);

 

Create Or replace procedure XML_SP (P_XML XMLType)

as

begin

Insert into xml_data_test Values ( (P_XML) );

end;

 

exec XML_SP ('<MAIN><INFO> <COLUMN_NAME>COL1</COLUMN_NAME><DATA_TYPE>CHAR(1)</DATA_TYPE></INFO></MAIN>');

 

Error report:

ORA-06550: line 1, column 7:

PLS-00306: wrong number or types of arguments in call to 'XML_SP'

 

How to insert the XML string to a xmltype table.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points