OraFAQ Forum: SQL & PL/SQL » SQL or other : Getting a list of files in a Server Directory

Home » SQL & PL/SQL » SQL & PL/SQL » SQL or other : Getting a list of files in a Server Directory

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL or other : Getting a list of files in a Server Directory [message #10392]

Tue, 20 January 2004 15:17

Imran
Messages: 56
Registered: November 2001

Member

Hi,

I am a relative newbie, to the relational side of things, having exclusively worked with OLAP databases so far.��

I am migrating an Oracle Express Application to Oracle OLAP 9i.� For some reason Oracle has removed some key I/O Express commands which we require in our application.� The FILEQUERY function no longer works as it used to.

Is there a function or can I write a function in SQL to be called, which can search a directory on the Database Server, and retrieve a list of files?

Regards,

Imran Shah

Ioppolo & Associates

ishah@ioppolo.com.au

Report message to a moderator

Re: SQL or other : Getting a list of files in a Server Directory [message #10393 is a reply to message #10392]

Tue, 20 January 2004 15:49

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Here is a method involving a Java stored procedure:

Retrieving list of files in directory

Report message to a moderator

Previous Topic:	Trigger - Check on the same table!
Next Topic:	Pivot Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 03:42:00 CDT 2024