Running my PL/SQL code as a Windows Server batch file
265441May 7 2011 — edited May 9 2011Developed PL/SQL programs using ORACLE SQL Developer on my client pc.
Example of two files
program1.sql
program2.sql
Want to move these files on the Oracle database server on Windows 2003 server.
Run them using the Scheduler via .cmd file
The contents of the file appear like this:
@C:\dataformats\sql\EMAIL_SSAF_UPDATE.SQL
@C:\dataformats\sql\ADDMIF.SQL
@C:\dataformats\sql\STOCK_RECEIPT.SQL
@C:\dataformats\sql\NO-STOCK.SQL
However these just opens up the ORACLE SQL Developer and doesn't execute. I'm obviously missing syntax. Passing on the oracle username/password etc.
How can I execute these programs one at a time in one batch file?
Thanks for your assistance.