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.