UNIX for Dummies Questions & Answers

Hi, can someone point out the tutorial or syntax for how to execute store procedure through shell scripting .

thanks.

You want to execute Database Stored Procedure?

can help .

There are numerous ways.. you can create a SQL script and call from shell using sqlplus -s user/pwd @sqlscript..

Elaborate your requirement..

Below is my script. I calling PS/SQL named:dummy_select. I dun know what's wrong of it...Getting error : wrong argument type.

function checkFileStatus
{

sqlplus -S $USER/$PASS@$DB << EOF
exec dummy_select('$1');
commit;
quit;
EOF

}


-----dummy PS/SQL--
CREATE OR REPLACE PROCEDURE dummy_select(
v_file_name VARCHAR2,
dummy_select_cv IN OUT Cv_Types.customer_tp)
IS
BEGIN

OPEN dummy_select_cv FOR

SELECT sysdate FROM dual;

END;
/

shell variables wont work inside the DB.
if am i right.

Make sure that you can run the SQL statement that you're passing through shell.. as you have an IN OUT parameter in your PL/SQL.. so you need to pass that in the SQL statement as well..