Home » RDBMS Server » Server Administration » Call Oracle Reports from Stored Procedure
Call Oracle Reports from Stored Procedure [message #369793] Thu, 12 October 2000 12:59 Go to next message
Samatha Gorrepati
Messages: 1
Registered: October 2000
Junior Member
HI,
I would like to call a Oracle Developer Report from a stored Procedure by passing in Parameters. I need to Call this Stored Procedure form ON_INSERT database trigger to send report as soon as a row is inserted into this table. I have lots of farmatting to do hence my choice is to use Developer Reports.
Please let me know if this is possible, if not is there any other Reporting tool that can be called from Stored PRocedures and if yes an example would be greatly appreciated.
Database Version 7.3.4 on HP Unix
Oracle Reports Version 6
Thanks,
Samatha

Report message to a moderator

Re: Call Oracle Reports from Stored Procedure [message #369823 is a reply to message #369793] Wed, 18 October 2000 20:43 Go to previous message
vanitha
Messages: 2
Registered: October 2000
Junior Member
U can use the run_product in the stored procedure.(if it from forms)
create a parameter list and pass the parameters using the parameterlist.

Report message to a moderator

Previous Topic: Cursor PROBLEM
Next Topic: trigger trouble
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 01:13:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.