Forum Stats

  • 3,840,087 Users
  • 2,262,565 Discussions
  • 7,901,148 Comments

Discussions

how to insert large XML(more than 4K chars) into XMLTYPE column using pro*c?

hi, I try to find some examples of inserting large XML(more than 4K chars) into XMLTYPE column using pro*c, but can't found.

currently, I have a method that inserts XML into XMLTYPE like that:

"EXEC SQL

AT :db__db_name

INSERT INTO XML_DATA_TABLE

(XML_DATA_UID, OBJECT_DB_UID, DOC_XML)

VALUES (:db__xml_data_uid, :db__data_db_uid, :db__xml_data);"

but when I try to insert large XML is not allowed.

if there is a simple way to insert large XML into XMLTYPE, I like for example.

I try to avoid using the oci methods, but if this the easy way, then I like examples of that as well, just please specify the files that need to include.

Tagged: