dbTalk Databases Forums  

Accessing files copied by UTL_FILE.FCOPY

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Accessing files copied by UTL_FILE.FCOPY in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #31  
Old   
Claus
 
Posts: n/a

Default Re: Accessing files copied by UTL_FILE.FCOPY - 10-01-2008 , 04:25 AM






On 30 Sep., 22:29, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote:

Quote:
use the dbms_scheduler ability (10g+) to run OS shell scripts that
will handle the file manipulation
Hi Mark,

I managed file ops to be handled by dbms_scheduler package. It's a bit
tricky, because one has to be very precises on how to wrap os commands
in batch files and how to call them via cmd.exe. Most examples I could
find turned out to have errors...

So, many thanks to you and Daniel
Claus.



Reply With Quote
  #32  
Old   
Claus
 
Posts: n/a

Default Re: Accessing files copied by UTL_FILE.FCOPY - 10-01-2008 , 04:25 AM






On 30 Sep., 22:29, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote:

Quote:
use the dbms_scheduler ability (10g+) to run OS shell scripts that
will handle the file manipulation
Hi Mark,

I managed file ops to be handled by dbms_scheduler package. It's a bit
tricky, because one has to be very precises on how to wrap os commands
in batch files and how to call them via cmd.exe. Most examples I could
find turned out to have errors...

So, many thanks to you and Daniel
Claus.



Reply With Quote
  #33  
Old   
Claus
 
Posts: n/a

Default Re: Accessing files copied by UTL_FILE.FCOPY - 10-01-2008 , 04:25 AM



On 30 Sep., 22:29, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote:

Quote:
use the dbms_scheduler ability (10g+) to run OS shell scripts that
will handle the file manipulation
Hi Mark,

I managed file ops to be handled by dbms_scheduler package. It's a bit
tricky, because one has to be very precises on how to wrap os commands
in batch files and how to call them via cmd.exe. Most examples I could
find turned out to have errors...

So, many thanks to you and Daniel
Claus.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.