BLOB used to store image in 9i is causing problem
I have an application developed in Oracle Developer 6i.
One of the forms captures the snaps of the applicants, the datatype being used BLOB. It works fine with Oracle 8i (8.1.5).When tested with Oracle 9i (release 2), the same form gives message "Transaction complete: 1 record applied and saved". But when searched or queried later, the fields of other datatypes are displayed, but the image item of datatype BLOB shows nothing (no snaps).
Any guidance wud be highly appreciated.
Thanking u in anticipation.