OraFAQ Forum: Unix » Passing Parameter from unix to plsql

Home » Infrastructure » Unix » Passing Parameter from unix to plsql (oracle 9.2 )

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

Passing Parameter from unix to plsql [message #542530]

Tue, 07 February 2012 13:52

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

Report message to a moderator