Home » Developer & Programmer » Reports & Discoverer » caling procedure in report
caling procedure in report [message #338268] Mon, 04 August 2008 06:50 Go to next message
aditiC
Messages: 38
Registered: February 2006
Location: INDIA
Member
Hello,

please let me know how to call a pl/sql procedure from report . using the prococedure i am inserting in a temporary table, the result of the temporary table needs to be displayed in the report.

Thanks in advance
Re: caling procedure in report [message #338270 is a reply to message #338268] Mon, 04 August 2008 06:52 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Call it from one of report's triggers (AFTER PARAMETER FORM could be a good choice, for example) by specifying its name (just as you'd do it from any PL/SQL code).
Re: caling procedure in report [message #339641 is a reply to message #338270] Fri, 08 August 2008 00:54 Go to previous messageGo to next message
aditiC
Messages: 38
Registered: February 2006
Location: INDIA
Member
During the report execution, i am calling a procedure to populate a temporary table. then i am displaying in report, the results from the temporary table. I need to truncate the table after every report execution. where and how can i specify that in the report code?

Please guide.


Many Thanks
Re: caling procedure in report [message #339649 is a reply to message #339641] Fri, 08 August 2008 01:18 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
AFTER REPORT trigger.
Previous Topic: XML Template
Next Topic: problem with lexical parameter
Goto Forum:
  


Current Time: Fri Dec 09 01:58:22 CST 2016

Total time taken to generate the page: 0.09083 seconds