Home » Infrastructure » Unix » Calling Pl/sql Stored Procedure from Unix shell script
icon14.gif  Calling Pl/sql Stored Procedure from Unix shell script [message #329522] Wed, 25 June 2008 11:57 Go to next message
apharnashri
Messages: 2
Registered: June 2008
Junior Member
Hi,
When I call a stored procedure from a shell script (say sample.sh) , I normally hardcode from userid and password. Is there any option to store the userids and passwords for different environments (say dev, uat, prd) in a seperate unix script instead of hardcoding in sample.sh..
Re: Calling Pl/sql Stored Procedure from Unix shell script [message #329523 is a reply to message #329522] Wed, 25 June 2008 11:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

What does the question or answer have to do with Oracle?
Re: Calling Pl/sql Stored Procedure from Unix shell script [message #329528 is a reply to message #329522] Wed, 25 June 2008 12:51 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Oracle Secure Password Store.

Regards
Michel
Previous Topic: Trouble : Backup fail someting
Next Topic: oracle username password visible
Goto Forum:
  


Current Time: Thu Mar 28 12:18:22 CDT 2024