Solved

Forms 10.1.2 Event engine cycle flow diagram.

Posted on 2006-10-19
3
453 Views
Last Modified: 2013-12-11
Dear Experts,

I have a desperate need to find a diagram that explains the way that Oracle Forms steps through the various triggers and events, which one starts when a form is opened and then the next and the next etc..

 I'm sure that there must be something out there as this is vital to understand where we need to put our code.

I'm also looking for the reason why, when I exit a form I get the following error: FRM-40350 Query caused no records to be retrieved. How can I prevent this error or possible catch it and suppress it?


Thanks again for your help.
0
Comment
Question by:Cosine_Consultants
3 Comments
 
LVL 12

Accepted Solution

by:
jwahl earned 500 total points
ID: 17786792
there is a forms built-in for debugging: Tools --> Preferences --> Tab Runtime --> set checkbox "Debug Messages".
this will show you the name of every trigger before it is executed.

regarding FRM-40350: this may be a message of a previous query that appears to "late". search for EXECUTE_QUERY or KEY-EXEQRY in your form (Program --> Find and Replace PL/SQL) to find out what queries are set up in your form.
as workaround to suppress this message you can also increase the message level, e.g.

DECLARE
    v_msg_level NUMBER := :SYSTEM.MESSAGE_LEVEL; -- store old level
DECLARE
    :SYSTEM.MESSAGE_LEVEL := 25; -- suppress ALL messages
    EXECUTE_QUERY;
    --
    -- your code ...
    --
    :SYSTEM.MESSAGE_LEVEL := v_msg_level; --restore message_level
    --
END;
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.

Join & Write a Comment

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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now