sqlplus calls from pl/sql [message #369692] |
Wed, 16 August 2000 12:17 |
Rob Rebelo
Messages: 2 Registered: August 2000
|
Junior Member |
|
|
Is there a way to execute sqlplus batch files from a pl/sql procedure.
In particular, I would like to run a sqlplus batch file using the dbms_job package.
|
|
|
Re: sqlplus calls from pl/sql [message #369704 is a reply to message #369692] |
Fri, 18 August 2000 14:48 |
devplsql
Messages: 1 Registered: August 2000
|
Junior Member |
|
|
I think you can do this thing by using dbms_pipe
package and you need to write a pro*C program
to recieve the sqlplus command from the pl/sql program and execute the system call in pro*c to call
sqlplus command.
|
|
|