Home » Infrastructure » Unix » pass arguments to a .sql file that is being called from a shell
pass arguments to a .sql file that is being called from a shell [message #213241] Wed, 10 January 2007 00:00 Go to next message
sanju.sinha@gmail.com
Messages: 30
Registered: November 2005
Member

Can you please help me understand how to pass arguments to a .sql file that is being called from a shell.

for example - In .sh file the lines are -
${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,
Re: pass arguments to a .sql file that is being called from a shell [message #213265 is a reply to message #213241] Wed, 10 January 2007 02:05 Go to previous message
sanju.sinha@gmail.com
Messages: 30
Registered: November 2005
Member

Hi,

I found the solution. Its available @
http://forums.oracle.com/forums/thread.jspa?messageID=1631385&#1631385



Thanks & regards,
Previous Topic: Database Server - Gap & Impact Analysis (Windows & UNIX)
Next Topic: Libraries are resetting the global environment
Goto Forum:
  


Current Time: Fri Dec 09 19:25:40 CST 2016

Total time taken to generate the page: 0.14056 seconds