Home » RDBMS Server » Server Administration » sqlplus calls from pl/sql
sqlplus calls from pl/sql [message #369692] Wed, 16 August 2000 12:17 Go to next message
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 Go to previous message
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.
Previous Topic: Multiple Oracles on NT
Next Topic: substr and instr functions
Goto Forum:
  


Current Time: Fri Mar 29 01:08:47 CDT 2024