SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creating windows .bat file from within an oracle .prc or .sql file

457641Sep 30 2005 — edited Oct 3 2005

I am currently converting a series of batch jobs on a windows server to use an Oracle db rather than a MS sql server db. In ms sql, I could call \mssql80\binn\isql and it allowed me to pass in .prc files and have a .bat file returned. the .bat file is then executed in the calling bat to set variable value returned in the sql call...

I am thinking I can spool a bat file, however, i do not know how to populate this file with the literals and query values needed to create the bat file which sets values used for further processing in the original calling bat file...

Does that make sense? any help is greatly appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2005

Added on Sep 30 2005

2 comments

731 views