calling SQLPLUS.EXE inside stored procedure

Hi,
I want to call SQLPLUS.EXE inside stored procedure, any tips or advise…i want to run our fully function production version of all hundreds sql script inside the packages/stored procedure. Any advise…

Thanks,
Romeo Romano

Hi Romeo,

I want to call SQLPLUS.EXE inside stored procedure, any tips or advise...i
want to run our fully function production version of all hundreds sql
script inside the packages/stored procedure. Any advise..

This prompts a bunch of questions, like "what version of Oracle?" and "what
exactly are you trying to accomplish?" and "did you know that the Oracle
Scheduler can run executable programs?".

However, since this is a list dedicated to Toad, you might have better luck
posting this to the ORACLE-L mailing list. Head to
http://www.freelists.org/webpage/oracle-l to sign up and gain posting privs.

Good luck!

Rich -- [TeamT]

Disclaimer: Stuck in a mine or a cubicle, it's the same amount of sunlight.