external LOBs (BFILEs) access using HTML and PHP

Help,

I have a table with a couple of external LOBs (BFILEs) that i need to access via HTML from a remote location. I have created two oracle directories and done the same at the OS level in the current server and at another remote server. Now I need to access those files to do search in them using the DBMS_LOB.INSTR() function and also display the actual path and file name using DBMS_LOB.FILEGETNAME().

This two DBMS_LOB functions are used in two different functions created in the schema of the user. Now one of them - the one displaying the path tells me that the file does not exist (DBMS_LOB.FILEEXISTS()) and the other one gives me an error telling me that the function does not guarantee that the function will not update the table even though i have setup the file to be open in readonly status.

I also placed both functions in a package using the PRAGMA restriction WNDS but then it specifies that still it contradicts the pragma.

Has anyone had a similar problem dealing with LOBs? And has anyone been able to use them while handling data with HTML and PHP?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 21 1999 - 10:49:34 CDT