Home » Infrastructure » Unix » Passing Parameter to stored procedures from unix
Passing Parameter to stored procedures from unix [message #300291] Thu, 14 February 2008 22:45 Go to next message
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.
Re: Passing Parameter to stored procedures from unix [message #300311 is a reply to message #300291] Fri, 15 February 2008 00:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
icon14.gif  Re: Passing Parameter to stored procedures from unix [message #300508 is a reply to message #300311] Fri, 15 February 2008 12:52 Go to previous message
kham2k
Messages: 34
Registered: May 2007
Member
Thanks
Previous Topic: Changing First line in existing Flat file
Next Topic: sys for sqlplus sys/sysadmin as sysdba
Goto Forum:
  


Current Time: Thu Mar 28 13:09:33 CDT 2024