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: Configuration for sending mails.
Next Topic: Swap Space Error -> installation 10g R2 on Solaris 10
Goto Forum:
  


Current Time: Sun Aug 20 10:42:02 CDT 2017

Total time taken to generate the page: 0.01295 seconds