DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to open bfile

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    Lightbulb

    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

  2. #2
    Join Date
    May 2001
    Posts
    2
    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

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    thanks

    Thanks manan
    anandkl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width