dbms_lob.fileopen hangs/won't return

From: doug <douglass_davis_at_earthlink.net>
Date: Mon, 27 Apr 2009 13:00:57 -0700 (PDT)
Message-ID: <5e662b8d-b7c8-4a15-b0cf-4523f263c50c_at_q33g2000pra.googlegroups.com>

Every time I run the code below, it just hangs. If I run it in SQL Developer it just sits there waiting on a response. Any one have any ideas why? This is a short version code I have in an application that opens a file/indexes the text, and it is causing the application to freeze up too.

        src_file BFILE;
        src_file := bfilename('SOME_DOC_DIR', '0.pdf');

  • open the file dbms_lob.fileopen(src_file, dbms_lob.file_readonly);
  • close the file dbms_lob.fileclose(src_file);

END; Thanks. Received on Mon Apr 27 2009 - 15:00:57 CDT

Original text of this message