I have a query as to how do we store a large xml say for ex more than 10000 bytes in oracle database. I tried using varchar but the length is limited to only 4000 bytes. Could any one please let me know how to achieve this.
Basically what I am trying to do is within adobe livecycle workflow I will get the user entered data in form as formData(xml) variable and I want to store the same for future reference. I need to use the same data to fill the form again in the future.
I tried using the BLOB type as you have mentioned but I am getting a type mismatch error. Please find the screenshot below.
I am saving a formData which is XML document, so it is because of this I am getting this error? If so, Can you please let me know how do I store the formData. Also I have attached the screenshot of Execute SQL statement. Please let me know If I am doing anything wrong here.
It will be great if you can share with any sample where a large formData is getting stored and retrieved back to the form.