| Re: starting a script from Delphi client application [message #373491] |
Thu, 19 April 2001 08:42 |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi,
The sql script is used to run multiple sqlstmts
from oracle's sql command line utils.
If you want to convert them in to procedure(PL/SQL) you have to rewrite 'em in PL/SQL.
you can't do like this
CREATE PROCEDURE (PARAM1 IN VARCHAR2, PARAM2 IN VARCHAR2) IS
begin
start script_A param1 param2;
end;
either you have hard code the script_a inside the proc or you can create another proc for script_a and call it from your master proc
like
begin
script_A_proc(param1, param2);
end;
Bala.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
