Solved

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

Posted on 2006-06-15
3
962 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

Suggested Solutions

Title # Comments Views Activity
ORA-01008: not all variables bound. 6 57
oracle 11g 23 83
Why  don't I see Below columns in my  Stored Procedure  under TMP_RS? 8 22
Select and Insert Query running slow 4 36
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…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

777 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