Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2006-06-15
3
Medium Priority
?
1,000 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
1 Comment
 
LVL 8

Accepted Solution

by:
sapnam earned 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

606 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