I need to run a .sql script from my shell script.

For eg. shell script A calls sql script B.sql by passing a parameter. There is a stored proc inside the B.sql which uses this parameter to execute the stored proc by passing this parameter as an input. How can this be done using shell scripts? Any ideas?

Try using sqlplus in your script:

Code:

sqlplus user/passwd@MyDB @B.sql PARM1