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

"Lakshmi Jagarlapudi" <jlnarayana_at_comcast.net> wrote

> However the procedure_name mentioned has some in and out parameters for it.
> How would i pass them to the
> procedure_name.

Simple example.

--
#!/bin/sh

# variables
FOO1=$1          # string variable for stored proc
FOO2=$2          # numeric variable for stored proc

sqlplus /nolog <<EOF

  connect scott/tiger

  begin
     -- stored proc takes varchar2 and number as input
     scott.foo_processor( '$FOO1', $FOO2 );
  end;
/

  exit;
EOF
--