Home » Developer & Programmer » Reports & Discoverer » pass value to stored procedure (10g, 6i, win8.1)
pass value to stored procedure [message #647608] Wed, 03 February 2016 23:30 Go to next message
rzkhan
Messages: 369
Registered: March 2005
Senior Member
I have a report based on the following query

select customerid,customername,get_cust_balnce(customerid,'2-FEB-2016') as amt_bal,
from customers

How can I pass a value to the stored procedure get_cust_balance(parm1, parm2) from reports parameter form?

Thanks

Re: pass value to stored procedure [message #647609 is a reply to message #647608] Wed, 03 February 2016 23:39 Go to previous messageGo to next message
ricky_s
Messages: 21
Registered: February 2016
Location: New Delhi, India
Junior Member
been a few years since i last worked on oracle reports but if i remember correctly it goes something like below


select customerid,customername,get_cust_balnce(:parm1,:parm2) as amt_bal from customers



just make sure these parameters are binded to a item on the report parameter form.
Re: pass value to stored procedure [message #647610 is a reply to message #647609] Wed, 03 February 2016 23:58 Go to previous message
rzkhan
Messages: 369
Registered: March 2005
Senior Member
Great ! It worked. Thanks ricky s

rzkhan
Previous Topic: rep-1517 which has incompatible frequency.
Next Topic: rdf designed using oracle 9i gives error REP-34551 while running in oracle 10g
Goto Forum:
  


Current Time: Mon Nov 18 15:01:03 CST 2019