Home » RDBMS Server » Server Administration » Re: starting a script from Delphi client application
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.
Previous Topic: ACCESS UPDATE != Oracle UPDATE ????
Next Topic: SSn
Goto Forum:
  


Current Time: Mon Dec 23 09:48:17 CST 2024