PL/SQL (MOSC)

MOSC Banner

BLOB Extraction for JPG files

edited Oct 6, 2009 10:45PM in PL/SQL (MOSC) 4 commentsAnswered
Hi,

 We are trying to extract the BLOB (JPG) to a local D drive and trying to view the .JPG file but it is not displaing properly.Please let me know if any one had the similary issue and able to resolve.

===
We used the below code to extract the JPG file.
-----------
declare
t_out_file UTL_FILE.file_type;
t_buffer VARCHAR2(32767);
t_amount BINARY_INTEGER := 1000;
t_pos INTEGER := 1;
t_clob_len INTEGER;
P_DATA BLOB;
P_DIR VARCHAR2(100) := 'IMAGES';
P_FILE VARCHAR2(100) := 'TEST.jpg';
BEGIN
select pict_test into P_DATA from test;
-- INSERT INTO BLOB_TABLE VALUES(P_DATA);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center