I need to pass the contents of an XML file (> than 32,767 bytes - the limit of varchar) to an Oracle stored procedure to be parsed and inserted into tables. It appears that ADO is incapable of passing a large amount of data like this. Has anyone done this?? One method I thought of is breaking the XML into multiple blocks, each of which could fit into a varchar, and concatenating them back together into a CLOB within the SP. But, I can't seem to assign text or varchar values to a CLOB variable.
Any suggestions would be greatly appreciated!
Thanks, Jeff
Any suggestions would be greatly appreciated!
Thanks, Jeff