how to get bfile's directory and filename
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