Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: calling pl/sql procedure from unix shell script (URGENT HELP REQUESTED)
Thanks for the reponse,
However the procedure_name mentioned has some in and out parameters for it.
How would i pass them to the
procedure_name. Please let me know.
Thanks,
"ReplyToGroups" <sorry_at_NoAddress.com> wrote in message
news:bpj7nd$4951_at_eccws12.dearborn.ford.com...
> 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 - 15:39:08 CST