MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

A better widget for capturing the fully qualified external file name

without comments

I’ve updated the how to return a fully qualified BFILE name from a function. The new function lets you select the fully qualified file name from a BFILE column, like:

SELECT get_canonical_local_bfilename(item_photo) AS file_name
FROM item
WHERE item_id = 1021;

In my test environment, it returns:

FILE_NAME
------------------------------------------
C:\JavaDev\BFileFramework\HarryPotter1.png

Written by maclochlainn

July 26th, 2008 at 10:36 pm

Posted in Oracle

Tagged with ,