Toad World® Forums

calling SQLPLUS.EXE inside stored procedure


#1

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


#2

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.