Solved

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

Posted on 2006-06-15
3
985 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
[X]
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
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious sideā€¦
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

691 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