Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2

    Unanswered: loading pdf files into bfile

    Hi,

    I am trying to load the pdf files into bfile.

    create directory TEST13 as 'C:\temp';

    grant read,write on directory TEST13 to public;

    create table test102(id number(4),aaa bfile);
    insert into test102 values(1234,bfilename('TEST13','sg1.pdf'));

    select * from test102;
    1234 (BFILE)

    select id, DBMS_LOB.GETLENGTH(aaa) from test102;

    ORA-22288: file or LOB operation GETLENGTH failed
    No such file or directory
    ORA-06512: at "SYS.DBMS_LOB", line 850
    22288. 00000 - "file or LOB operation %s failed\n%s"
    *Cause: The operation attempted on the file or LOB failed.
    *Action: See the next error message in the error stack for more detailed
    information. Also, verify that the file or LOB exists and that
    the necessary privileges are set for the specified operation. If
    the error still persists, report the error to the DBA.

    I stored some pdf files in c:\temp in local machine. DBA suggests not to put the files on DB server. Is there a way to read the pdf files without storing them in DB server?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    No. A directory must point to a volume on the database server. Your DBA is mistaken.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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