OraFAQ Forum: Unix » Passing Parameter to stored procedures from unix

Home » Infrastructure » Unix » Passing Parameter to stored procedures from unix

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

Passing Parameter to stored procedures from unix [message #300291]

Thu, 14 February 2008 22:45

kham2k
Messages: 34
Registered: May 2007

Member

Hi All,

How can I pass values to a stored procedure from unix.

New_FILE_NAME=$(echo $FILE_NAME | sed s/\.txt//)
sqlplus $user_name/$passwd 
exec store_proc($New_FILE_NAME)
exit;

I can't pass the file name like this to procedure. How can I do it?

Thanks

p.s. I hope this is considered as oracle related question and I am posting it under the right forum.

Report message to a moderator

Re: Passing Parameter to stored procedures from unix [message #300311 is a reply to message #300291]

Fri, 15 February 2008 00:23

Michel Cadot
Messages: 68455
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

http://www.orafaq.com/forum/?SQ=33d66323e86a5ee99dc649a5dc878083&t=search&srch=Passing+Parameter+unix&btn_submit=Search&a mp;field=all&forum_limiter=29&search_logic=AND&sort_order=DESC&author=

Regards
Michel

Report message to a moderator

Re: Passing Parameter to stored procedures from unix [message #300508 is a reply to message #300311]

Fri, 15 February 2008 12:52

kham2k
Messages: 34
Registered: May 2007

Member

Thanks

Report message to a moderator

Previous Topic:	Changing First line in existing Flat file
Next Topic:	sys for sqlplus sys/sysadmin as sysdba

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 08 10:39:44 CDT 2023