Re: calling pl/sql procedure from unix shell script (URGENT HELP REQUESTED)

sqlplus $SQLPLUS_LOGIN/$SQLPLUS_PASSWORD @$BIN_DIR/xyz.sql

sqlplus_rtn_code=$?

return $sqlplus_rtn_code

Here replace login,plassord with your login name and pwd...

In xyz.sql contains

begin

  execute procedure_name

end ;

"Lakshmi Jagarlapudi" <jlnarayana_at_comcast.net> wrote in message news:MG7vb.59810$Dw6.326051_at_attbi_s02...
> Can any one tell me how do I call a pl/sql procedure from a unix shell
> script.I
> donot have unix access at home, but I am guessing that this might work.
any
> ideas
> please.
>
> assuming that the pl/sql procedure takes 2 in parameters and 2 out
> parameters
>
> sqlplus -s user/passwd_at_connstr << TOKEN
> begin
> myproc(outbuf,outcode,inbuf,incode);
> end;
> TOKEN
>
>
>
> Please let me know if this works.
>
> thanks,
>
>
Received on Thu Nov 20 2003 - 14:21:00 CST