Greetings to all Experts,
Can you please let me know how to extract blob data and save to file in readable format.
I had developed a Pl/SQl and used DBMS_LOB.READ for reading data from blob field and UTL_FILE.PUT to write to a file.
DBMS_LOB.READ( IBLOB, L_AMOUNT, L_POS, L_BUFFER);
UTL_FILE.PUT(L_FILE, L_BUFFER);
The procedure got compiled successfully and when I executed a file is getting generated but with @@@@@@ symbols instead of actual data.
Please help what changes I have to do to code.