How to Call Oracle stored function within shell script

I am trying to write a shell script that should call an Oracle stored function. Some values needs to be passed to this function, and it would also return one value. Please help me on it.
taniatangriAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
stefan73Connect With a Mentor Commented:
Hi taniatangri,
Use sqlplus:

sqlplus login/password@instance << EOL
begin
    ...
end
/
quit
EOL


Cheers!

Stefan
0
 
stefan73Commented:
(Be aware that anyone can see your user and password using the "ps" tool this way)
0
 
dsackerConnect With a Mentor Contract ERP Admin/ConsultantCommented:
You can also hide your logon/password with the following:

sqlplus /nolog << EOL
connect login/password@instance
declare
    return_value    varchar2(32);    -- change the type if you are returning another type
begin
    return_value := my_stored_function(passed_value1, passed_value2);
end;
/
quit
EOL
0
 
manav_mathurCommented:
Taniatangri,

Do you want to pass UNIX variables to your Oracle SP??
and do you want the oracle returned values in UNIX too?? Coz then the scenario changes

Manav
0
All Courses

From novice to tech pro — start learning today.