Unanswered: Bfile images don't showup after upgrade from 8.1.6 to 8.1.7!!!!!
I upgrade Oracle 8.1.6 to 8.1.7 and upgrade intermeida also, but after this, all images I can see before now become strang machine symbols. Please help. Thanks a lot!
Here is a piece of my code, it works in 8.1.6 :
PROCEDURE bfileshow (bfilein bfile)
l_amt BINARY_INTEGER :=4096;
l_off INTEGER :=1;
DBMS_LOB.FILEOPEN (mybfile, DBMS_LOB.FILE_READONLY);
DBMS_LOB.READ (mybfile, l_amt, l_off,l_raw);
WHEN NO_DATA_FOUND THEN