this is demo table
SQL> desc pm.PRINT_MEDIA;
Name Null? Type
----------------------------------------- -------- ----------------------------
PRODUCT_ID NOT NULL NUMBER(6)
AD_ID NOT NULL NUMBER(6)
AD_COMPOSITE BLOB
AD_SOURCETEXT CLOB
AD_FINALTEXT CLOB
AD_FLTEXTN NCLOB
AD_TEXTDOCS_NTAB PM.TEXTDOC_TAB
AD_PHOTO BLOB
AD_GRAPHIC BINARY FILE LOB
AD_HEADER PM.ADHEADER_TYP


how can I get dirctory and file name for field AD_GRAPHIC.

which function I can use.

bfilename is used to insert data into tables.
In Oracle/PLSQL, the bfilename function returns a BFILE locator for a physical LOB binary file.

The syntax for the bfilename function is:

bfilename( 'directory', 'filename' )

now, I have file locator, AD_GRAPHIC, how can I get directory and filename?

Thanks.
xyz2000