Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2006-06-15
3
Medium Priority
?
996 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 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

604 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