SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to pass arguments to .sql file.......

sanju2Jan 9 2007 — edited Jan 10 2007

Hello,

I want to pass arguments to .sql file which is being called from within a shell (.sh).

suppose this is the line in shell -
${ORACLE_HOME}/bin/sqlplus -s abcuser/abcuser@abc < ${ABCDB_DIR}/A.sql $val >>${LOG}

- now I want to pass '123456' to A.sql

Please suggest how to do that.

Thanks and regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2007

Added on Jan 9 2007

8 comments

8,188 views