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

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 - 12:25:49 CST