OraFAQ Forum: Unix » Calling Pl/sql Stored Procedure from Unix shell script

Home » Infrastructure » Unix » Calling Pl/sql Stored Procedure from Unix shell script

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

Calling Pl/sql Stored Procedure from Unix shell script [message #329522]

Wed, 25 June 2008 11:57

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..

Report message to a moderator

Re: Calling Pl/sql Stored Procedure from Unix shell script [message #329523 is a reply to message #329522]

Wed, 25 June 2008 11:59

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?

Report message to a moderator

Re: Calling Pl/sql Stored Procedure from Unix shell script [message #329528 is a reply to message #329522]

Wed, 25 June 2008 12:51

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

Senior Member
Account Moderator

Use Oracle Secure Password Store.

Regards
Michel

Report message to a moderator

Previous Topic:	Trouble : Backup fail someting
Next Topic:	oracle username password visible

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 22:48:52 CST 2025