OraFAQ Forum: Forms » running reports from forms in oracle 10g

Home » Developer & Programmer » Forms » running reports from forms in oracle 10g

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

running reports from forms in oracle 10g [message #427371]

Thu, 22 October 2009 04:47

mandark
Messages: 23
Registered: October 2009

Junior Member

Hi,
I have converted rports in oracle 6i to oracle 10g version by compiling those reports in reports builder.
Now i able to run reports in report builder, but while trying to run reports from forms, it is giving error "FRM 21011:PL/SQL unhandled exception ORA-06508". even though *.rdf file is present in proper location.

Report message to a moderator

Re: running reports from forms in oracle 10g [message #427480 is a reply to message #427371]

Thu, 22 October 2009 16:01

dlwixon
Messages: 92
Registered: September 2008

Member

Try using the web.show_document() built-in.

Report message to a moderator

Re: running reports from forms in oracle 10g [message #427507 is a reply to message #427371]

Fri, 23 October 2009 00:13

mandark
Messages: 23
Registered: October 2009

Junior Member

I am using rp2rro.rp2rro_run_product() to call reports, won't it work?

Report message to a moderator

Re: running reports from forms in oracle 10g [message #427611 is a reply to message #427371]

Fri, 23 October 2009 08:29

rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon

Senior Member

Don't forget also to attach the report to the form.

Rajy

Report message to a moderator

Re: running reports from forms in oracle 10g [message #427714 is a reply to message #427371]

Sat, 24 October 2009 03:58

psingh7777
Messages: 22
Registered: August 2007
Location: New Delhi

Junior Member

Report object needs to be attached/added in report calling form.

Report message to a moderator

Re: running reports from forms in oracle 10g [message #427865 is a reply to message #427371]

Mon, 26 October 2009 04:42

mandark
Messages: 23
Registered: October 2009

Junior Member

but when i use function rp2rro.rp2rro_run_product(), i am still getting error "FRM-21011: PL/SQL unhandled exception ORA-06508.
please Help me with this.

Report message to a moderator

Re: running reports from forms in oracle 10g [message #428422 is a reply to message #427865]

Wed, 28 October 2009 05:41

mandark
Messages: 23
Registered: October 2009

Junior Member

Thanks, using web.show)document() problem is solved.

Report message to a moderator

Previous Topic:	error while running reports
Next Topic:	Forms to write pdf directly to database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 02:37:08 CST 2025