Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BLOB column not updating using automated row processing

mooJun 22 2011 — edited Jun 23 2011
I have fiddled around with creating a simple application to understand how APEX handles images stored in blobs - did a simple app that stores them, gets them, displays them. it all works great.

so i have this existing table/application that i am trying to add a BLOB column to here's what i did:

it's a pretty simple form on a table with report application. just one table.
I added the BLOB to the table (and the other mimetype etc cols as well).
i added the page items to the form page.
i basically made everything identical in terms of page item settings and such to the working simple application.

so here's the problem... when i run the application and update a row, the BLOB column isn't updating. neither are the mimetype or filename columns. the activity date col is.
and here's another interesting thing. i quickly created another form and report pair on the same table, and when i ran it, it updates the blob col just fine.

why is my original form not updating it? what can i do to remedy this? any ideas? i've gone though setting by setting for the blob page item and the one that works is identical to the one that doesn't.

i'm using the automatic row processing to update the table.

Edited by: moo on Jun 23, 2011 5:33 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2011
Added on Jun 22 2011
0 comments
274 views