3 Replies Latest reply: Jul 30, 2013 4:31 AM by odie_63 RSS

    Not able to pass input to XMLType datatype.

    936666

      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.