Home » Developer & Programmer » Reports & Discoverer » PL/SQL query (Reports 6i)
PL/SQL query [message #453179] Tue, 27 April 2010 12:07 Go to next message
Amine
Messages: 376
Registered: March 2010
Senior Member

Hi All,
I want to use a procedure that returns SYS_REFCURSOR in a report.
How can I use the PL/SQL query builder to do that ?

Thank you

Amine
Re: PL/SQL query [message #453181 is a reply to message #453179] Tue, 27 April 2010 12:18 Go to previous message
cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you start up report builder help and type "ref cursor" into the search field the 2nd topic in the list is:
Creating a query: Ref Cursor Query tool

Try following the instructions in that and get back to us if have a problem.
Previous Topic: how to use updated temptable data in report
Next Topic: Lexcial Parameter inside PLSQL (in Formula Column)
Goto Forum:
  


Current Time: Sat Nov 30 10:46:50 CST 2024