Save large form data in Oracle database

Shekh1991 20-01-2015

Hi All,

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.

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Answers (5)

Answers (5)

Shekh1991 08-02-2015

Hi Wasil,

Sorry for the delayed response.

I tried the above sample with Oracle database but I got a error saying "Exception: Missing IN or OUT parameter at index:: 2". I tried searching for the possible reason but no luck.

In another approach i tried using CLOB datatype. In this case I was able to store the formdata but could not retrieve. I am getting a error as shown in the below screenshot.

Error.JPG

Any inputs will be highly appreciated.

Thanks,

Shekhar

Shekh1991 21-01-2015

Hi Wasil,

Thanks for your reply.

I tried using the BLOB type as you have mentioned but I am getting a type mismatch error. Please find the screenshot below.

SQL_Error.jpg

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.

ExecuteStatement.jpg

It will be great if you can share with any sample where a large formData is getting stored and retrieved back to the form.

Just a note I am using Oracle database

Thanks in advance.

Shekhar