Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Calling reports from a form with 10g Oracle Developer using when button pressed.

Posted on 2006-06-15
3
970 Views
Last Modified: 2013-12-12
Help, I'm getting FRM-40735 WHEN_BUTTON_PRESSED trigger raised unhandled exception ORA-06508. I created a form and then used two buttons to call two different reports then of course I have an exit button.

I can't get the form to call the reports.  I used the Run_Report_objects since the Run_product woudn't work.

I don't know if I need to create some procedure or what's necessary.

Help..
0
Comment
Question by:ValeneSue
3 Comments
 
LVL 8

Accepted Solution

by:
sapnam earned 500 total points
ID: 16931783
Can you post your code here, the code which you have written for WHEN-BUTTON-PRESSED.  ORA-06508 error is encountered when stored procedures/functions are not found.  I have given the cause and action below. I cant figure out why you are getting this in WHEN-BUTTON-PRESSED unless you are making a call to a stored procedure somewhere.  So post your code and we will go forward


ORA-06508: PL/SQL: could not find program unit being called
Cause: An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors.
Action: Check that all referenced programs, including their package bodies, exist and are compatible.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to take different types of Oracle backups using RMAN.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question