-
Hi all,
I am trying to open an image file using bfile datatype.I have created a directory object.
Then i wrote this procedure.It sucessfully complied and i executed the procedure it executed but i am not able to see the image.Could any one help me on this.My procedure looks like this
CREATE OR REPLACE PROCEDURE readBFILE_proc IS
Lob_loc BFILE := BFILENAME('mydir', 'Techops');
Amount INTEGER :=32767 ;
Position INTEGER := 1;
Buffer RAW(32767);
BEGIN
/* Select the LOB: */
SELECT f_lob INTO Lob_loc FROM lob_table
WHERE Key_Value = 21;
/* Open the BFILE: */
DBMS_LOB.OPEN(Lob_loc, DBMS_LOB.LOB_READONLY);
/* Read data: */
DBMS_LOB.READ(Lob_loc, Amount, Position, Buffer);
/* Close the BFILE: */
DBMS_LOB.FILEOPEN(Lob_loc,dbms_lob.file_readonly);
--dbms_output.fileclose(Lob_loc);
--dbms_output.put_line('Read F1 past EOF: '||
--utl_raw.cast_to_varchar2(buffer));
DBMS_LOB.CLOSE(Lob_loc);
END;
Please help me on this
thanks in advance
anandkl
-
dear anandki
well i would like to suggest u something.If ur intentions r to see the image file u need to use front tool like oracle developer or vb.on sql prompt u cant find the size,existence etc but u cant open this file.If u want an example u can mail me on cmanan@hotmail.com.i'll try to help to the extent i can.
Manan
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|