Home » Developer & Programmer » Forms » running reports from forms in oracle 10g
running reports from forms in oracle 10g [message #427371] Thu, 22 October 2009 04:47 Go to next message
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.

Re: running reports from forms in oracle 10g [message #427480 is a reply to message #427371] Thu, 22 October 2009 16:01 Go to previous messageGo to next message
dlwixon
Messages: 92
Registered: September 2008
Member


Try using the web.show_document() built-in.
Re: running reports from forms in oracle 10g [message #427507 is a reply to message #427371] Fri, 23 October 2009 00:13 Go to previous messageGo to next message
mandark
Messages: 23
Registered: October 2009
Junior Member
I am using rp2rro.rp2rro_run_product() to call reports, won't it work?
Re: running reports from forms in oracle 10g [message #427611 is a reply to message #427371] Fri, 23 October 2009 08:29 Go to previous messageGo to next message
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
Don't forget also to attach the report to the form.

Rajy
Re: running reports from forms in oracle 10g [message #427714 is a reply to message #427371] Sat, 24 October 2009 03:58 Go to previous messageGo to next message
psingh7777
Messages: 22
Registered: August 2007
Location: New Delhi
Junior Member

Report object needs to be attached/added in report calling form.
Re: running reports from forms in oracle 10g [message #427865 is a reply to message #427371] Mon, 26 October 2009 04:42 Go to previous messageGo to next message
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.
Re: running reports from forms in oracle 10g [message #428422 is a reply to message #427865] Wed, 28 October 2009 05:41 Go to previous message
mandark
Messages: 23
Registered: October 2009
Junior Member
Thanks, using web.show)document() problem is solved.
Previous Topic: error while running reports
Next Topic: Forms to write pdf directly to database
Goto Forum:
  


Current Time: Fri Dec 09 03:36:35 CST 2016

Total time taken to generate the page: 0.07223 seconds