OraFAQ Forum: Reports & Discoverer » pass value to stored procedure

Home » Developer & Programmer » Reports & Discoverer » pass value to stored procedure (10g, 6i, win8.1)

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

pass value to stored procedure [message #647608]

Wed, 03 February 2016 23:30

rzkhan
Messages: 370
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

Report message to a moderator

Re: pass value to stored procedure [message #647609 is a reply to message #647608]

Wed, 03 February 2016 23:39

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.

Report message to a moderator

Re: pass value to stored procedure [message #647610 is a reply to message #647609]

Wed, 03 February 2016 23:58

rzkhan
Messages: 370
Registered: March 2005

Senior Member

Great ! It worked. Thanks ricky s

rzkhan

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 01 05:54:39 CDT 2023