in reply to Ora_blob being treated as undefined?

This is an Oracle question. Is it a BLOB or a BFILE? Normally, Oracle stores BLOBs inline (in the column, in the row of the datafile). When you store the .pdf on the filesystem, the table column only stores the LOB locator, not the actual binary data. To access the filesystem for a BFILE, you build a LOB locator by putting together the directory name plus the filename. (the directory part is the alias from the Oracle "create or replace directory" command)

Your error may be that you are reading a LOB locator and thinking it is a .pdf ??

Please specify more, and maybe I can answer more specifically.

  • Comment on Re: Ora_blob being treated as undefined?

Replies are listed 'Best First'.
Re^2: Ora_blob being treated as undefined?
by c0bra (Acolyte) on Sep 10, 2004 at 18:16 UTC
    I'm no Oracle whiz, but according to TOAD it's being stored in a BLOB. I actually have no idea what a BFILE is :( (I don't get access to all the fun db stuff).

    When I dump the hash I can see the pdf headers in the binary so I'm thinking it's coming out right... kinda.