OraFAQ Forum: Reports & Discoverer » How to call report in PLSQL?

Home » Developer & Programmer » Reports & Discoverer » How to call report in PLSQL?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to call report in PLSQL? [message #335616]

Wed, 23 July 2008 00:25

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which kind of report? SQL script?

Regards
Michel

Report message to a moderator

Re: How to call report in PLSQL? [message #335655 is a reply to message #335616]

Wed, 23 July 2008 03:02

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.

Report message to a moderator

Re: How to call report in PLSQL? [message #335665 is a reply to message #335655]

Wed, 23 July 2008 04:02

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 08:26:00 CST 2024