OraFAQ Forum: Unix » pass arguments to a .sql file that is being called from a shell

Home » Infrastructure » Unix » pass arguments to a .sql file that is being called from a shell

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pass arguments to a .sql file that is being called from a shell [message #213241]

Wed, 10 January 2007 00:00

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,

Report message to a moderator

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

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,

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 30 10:36:42 CDT 2025