OraFAQ Forum: SQL & PL/SQL » Urgent Help required:Utl File

Home » SQL & PL/SQL » SQL & PL/SQL » Urgent Help required:Utl File

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

Urgent Help required:Utl File [message #38358]

Mon, 15 April 2002 05:53

krb
Messages: 25
Registered: March 2002

Junior Member

hi,
I have a requirement, I will be reading a file from the server using util_file package. Once the I have finished reading the file, I need to move the file to a different directory. How do I do this. If I work from sql plus then Host command works, but how will do the same in a procedure.
I am using NT server

thanks
KRB

Report message to a moderator

Re: Urgent Help required:Utl File [message #38372 is a reply to message #38358]

Mon, 15 April 2002 17:36

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You can use an external proc (written in C), or, if you are on 8i, a Java stored procedure.

Report message to a moderator

Re: Urgent Help required:Utl File [message #38390 is a reply to message #38372]

Tue, 16 April 2002 07:23

krb
Messages: 25
Registered: March 2002

Junior Member

How will I call c procedure in Ora Procedure

Report message to a moderator

Re: Urgent Help required:Utl File [message #38397 is a reply to message #38372]

Tue, 16 April 2002 17:22

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Look in the documentation under extproc. Here is an example:

http://asktom.oracle.com/pls/ask/f?p=4950:8:698923::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1200435685237,%7Bextproc%7D

Report message to a moderator

Previous Topic:	Re: Trigger not seeing uncommitted values
Next Topic:	Help .... !! Is it possible to delete file from Stored Procedure.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 05:41:04 CDT 2024