Rafael
07-Feb-2025 17:32:02
*Here's the situation:*
I'm migrating a bunch of Oracle Forms applications running on a remote Oracle 11g database.
We can't update the database until we finish migrating all applications.
So far, so good.
I have a requirement to upload photos to the remote database in one of these applications.
So I wrapped my BLOB column in a scalar subquery expression like this:
SELECT name, (SELECT image FROM dual) AS image FROM table;
It works, but APEX sets the image column type to Plain Text.
If I change it to Display Image, APEX throws an error:
*Backtrace: ORA-06512: in "APEX_240100.WWV_FLOW_IR_RENDER*".
If I change it to Avatar, it displays the image, but it's not the way I need it.
I created a local table in APEX with the same fields as the remote database.
If I upload the photos to the local database, I can set the type to Display Image.
The downside of this solution is the need to synchronize both tables.
Does anyone have a better solution?