OraFAQ Forum: SQL & PL/SQL » sql code asking for username and password when running a batch file

Home » SQL & PL/SQL » SQL & PL/SQL » sql code asking for username and password when running a batch file

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

sql code asking for username and password when running a batch file [message #229665]

Mon, 09 April 2007 10:08

mlgonsalv
Messages: 35
Registered: March 2005
Location: DC

Member

Greetings to all Gurus!
I have a batch file when runs calls an sql file and generates sql reports into user's local directory. Instead of hardcoding username/password@db_string in the batch script, how to ask for username and password each time when the batchfile is run? Any tips would be greatly appreciated.
Thanks much.
MG

--my batch file
sqlplus username/password@db_string @//apps/oraapps/myfile.sql

Report message to a moderator

Re: sql code asking for username and password when running a batch file [message #229667 is a reply to message #229665]

Mon, 09 April 2007 10:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use something like:

Accept username char prompt "username? "
Accept pws char prompt "password? " hide
Accept srv char prompt "service name? "
connect &username/&psw@&srv
...

Then

sqlplus /nolog @/apps/oraapps/myfile.sql

Regards
Michel

Report message to a moderator

Re: sql code asking for username and password when running a batch file [message #229970 is a reply to message #229667]

Tue, 10 April 2007 08:00

mlgonsalv
Messages: 35
Registered: March 2005
Location: DC

Member

Wonderful!!
Thanks Michel.

Report message to a moderator

Previous Topic:	Create View Problem
Next Topic:	trigger help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 14:40:41 CST 2024