Home » Developer & Programmer » Reports & Discoverer » How to call report in PLSQL?
How to call report in PLSQL? [message #335616] Wed, 23 July 2008 00:25 Go to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
Is there any method to call oracle report through PLSQL stored procedure? if Yes,how?

[EDITED by LF: removed unnecessary [code] tags]

[Updated on: Wed, 23 July 2008 16:22] by Moderator

Report message to a moderator

Re: How to call report in PLSQL? [message #335627 is a reply to message #335616] Wed, 23 July 2008 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which kind of report? SQL script?

Regards
Michel
Re: How to call report in PLSQL? [message #335655 is a reply to message #335616] Wed, 23 July 2008 03:02 Go to previous messageGo to next message
sandipshahare
Messages: 21
Registered: March 2008
Location: Pune
Junior Member
If you want to run the report though a report server ,then you need to create the report URL by taking all the required parameters.
You can do this in a procedure and then pass this URL through srw.ren_report(URL).

This may be work.
Re: How to call report in PLSQL? [message #335665 is a reply to message #335655] Wed, 23 July 2008 04:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
This may be work.

Or not at all as you don't know which kind of report OP is talking about.
For myself, I don't anything like "srw.ren_report" to pass any URL, and then which url?

Regards
Michel

[Updated on: Wed, 23 July 2008 04:02]

Report message to a moderator

Re: How to call report in PLSQL? [message #335703 is a reply to message #335665] Wed, 23 July 2008 06:14 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
currently , I am invoking reports 6i executable file through forms 6i by using run_report method.
But as per requirement , i need to invoke the same report
through PLSQL stored procedure instead of forms 6i.
is it possible ? if yes , how can i achieve this task?

[EDITED by LF: removed unnecessary [code] tags]

[Updated on: Wed, 23 July 2008 16:22] by Moderator

Report message to a moderator

Re: How to call report in PLSQL? [message #335708 is a reply to message #335703] Wed, 23 July 2008 06:54 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So this should be posted in Reports forum.
And if you don't post code don't use code tags.

Regards
Michel

Previous Topic: My JOB is in DANGER....Please give some time to my probs.
Next Topic: PRINT JOB Parameter Usage in 9i Reports
Goto Forum:
  


Current Time: Wed Dec 07 02:48:28 CST 2016

Total time taken to generate the page: 0.14099 seconds