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

Report message to a moderator

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: 21823
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).

Report message to a moderator

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

Report message to a moderator

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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
AFTER REPORT trigger.

Report message to a moderator

Previous Topic: XML Template
Next Topic: problem with lexical parameter
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 23:35:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.