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

Report message to a moderator

Previous Topic: Off Topic - Unix Question
Next Topic: Re: plz answer these questions...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 18 07:03:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.