Re: SQL*PLUS

Create a file called prx.cmd that contains the line  sqlplus uid/pwd_at_service @prx.sql

where uid = used id
pwd = password
service = tnsname of db
and prx.sql contains the lines

   exec proc('XXX','YYY');
   exit;

Doug Coan
Senior Client Server Systems Integrator dcoan_at_aegonusa.com

On Thu, 12 Aug 1999 19:14:19 GMT, Nandakumar <N.Kumar_at_rocketmail.com> wrote:

>i have a procedure named proc which accepts two arguments.
>Every time i run that on SQL*PLUS prompt, like
> exec proc('XXX','YYY');
>
>I want to know if there is a way to run it using some alias like in
>UNIX SHELL.
>
>Say if i run "prx", it should run "exec proc('XXX','YYY');"
>
>--
>Nandakumar
>Systems Analyst
>New York
>(N.Kumar_at_rocketmail.com)
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

Doug Coan
Senior Client Server Systems Integrator DCoan_at_aegonusa.com
"Live to Learn and Learn to Live" Received on Thu Aug 12 1999 - 20:54:54 CDT