how to call oracle package procedure from DOS batch file?

From: Guang Mei <GMei_at_ph.com>
Date: Fri, 4 Mar 2005 16:54:12 -0500
Message-ID: <7E62D965D357694C993D4F0E13B3C39B04D37F40@phexchange.ph.com>

Hi,

Just started to program on WindowXP side using DOS batch file. I have this question.

In batch file, if I want to call a procedure in a package with parameters defined in the batch file, how do I do that?

REM : try to call my_package.my_procedure with two parameters REM: %1 is user/pass_at_db

sqlplus -S %1 "exec my_package.my_procedure (:%2, :3% ) << EOF exit
EOF does not seem to work.

TIA. Guang

PRIVILEGED AND CONFIDENTIAL:
This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 04 2005 - 16:57:34 CST