Home » Infrastructure » Unix » Passing Parameter from unix to plsql (oracle 9.2 )
Passing Parameter from unix to plsql [message #542530] Tue, 07 February 2012 13:52 Go to next message
vinodprakash
Messages: 2
Registered: September 2011
Location: India
Junior Member
hi every1

I want to pass report_id value stored in a file in unix to plsql procedure. The report_id value is used in the query to fetch the data from db tables...

select emp_name,emp_salary
from employee
where emp_id = report_id


I need to know the command and also the syntex to write as to have to pass the parameter value to plsql..

Needs it urgently....

Thanks in Adavances..



Re: Passing Parameter from unix to plsql [message #542531 is a reply to message #542530] Tue, 07 February 2012 13:54 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does this help?
Re: Passing Parameter from unix to plsql [message #542533 is a reply to message #542531] Tue, 07 February 2012 14:04 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Previous Topic: Not able to transfer a file using SCP
Next Topic: Not able to export ORACLE_SID and ORACLE_HOME
Goto Forum:
  


Current Time: Fri Mar 29 05:13:01 CDT 2024