Home » Infrastructure » Unix » Re: how to run a stored proc from shell file?
Re: how to run a stored proc from shell file? [message #97760] Wed, 08 January 2003 09:28
EAP
Messages: 2
Registered: January 2003
Junior Member
Following is the example. Hope it helps you ..
Below code is for Unix Shell script :-

sqlplus -s <<SQLPLUS_END1
Username/password@$database_svr_name

DECLARE
result_cnt number := 0;
BEGIN
/* Stored Procedure. Pkg_Name.Proc_Name */
extract_pkg.get_upd('ABCD');

END IF;

COMMIT;
END;
/
SQLPLUS_END1
Previous Topic: Off Topic - Unix Question
Next Topic: Re: plz answer these questions...
Goto Forum:
  


Current Time: Thu Mar 28 08:54:47 CDT 2024