How to put image from ImageField into an Oracle Database

[Former Community Member]

Does anyone know how to take the Base64 value from an Imagefield and Insert it into a CLOB or BLOB field?

[Srini_Dhulipall]

This is how we did in the past.

1. Created a schema and bound the Image field to a tag in the Schema.

2. When the form is Submitted, the XML data will have the Image Base 64 encoding in the tag that the Image field is bound to.

3. You can use the normal XML parsing to get the tag value and store it into Database field.

Thanks

Srini

[Former Community Member]

I appreciate the advise, but I'm not sure if I can get the database folks to make the changes.  They have a Stored Procedure in the database for consuming LOB data.  Is there a way to execute the stored procedure and pass it the Base64 data?  This is new to me.  So, any help would be greatly appreciated.

Jimmy

[Former Community Member]

Base64 is just bytes encoded into a string.

You may have to decode it back to byte array in order to save as BLOB or LOB.