How to call SQL procedure from UNIX Shellscript ?

Hi All

I would be thankful to you all if you will guide me the steps to call a stored proc. from unix shell script. that stored proc. could be parameterised or parameterless developed in SQL.

Any info. in this topic would help me.....
Thanks in advance....

If you are asking how to call sqlplus with some type of sql script or you want to pass shell variables to sql scripts, please search the forums. This question is asked almost daily.

If you do not know how to call a stored procedure from sqlplus, then we can answer that.