Save large form data in Oracle database

Avatar

Avatar

Shekh1991

Avatar

Shekh1991

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)

Avatar

Avatar

WASIL

Employee

Avatar

WASIL

Employee

WASIL
Employee

22-01-2015

Shekhar,

I had MySQL handy, so I did using that and attached here is a sample. For Oracle, it is assignment for you along with retrieval.

-Wasil

Answers (5)

Answers (5)

Avatar

Avatar

Beraroma

Avatar

Beraroma

Beraroma

11-05-2020

Hi I have the same problem please you can help me!!! 

Avatar

Avatar

Shekh1991

Avatar

Shekh1991

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

Avatar

Avatar

Shekh1991

Avatar

Shekh1991

Shekh1991

22-01-2015

Thanks a lot Wasil.

I will try with oracle and let you know about my findings.

Avatar

Avatar

Shekh1991

Avatar

Shekh1991

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

Avatar

Avatar

WASIL

Employee

Avatar

WASIL

Employee

WASIL
Employee

21-01-2015

You should use JDBC blob type.

BLOB.jpg

-Wasil