Solved

Forms 10.1.2 Event engine cycle flow diagram.

Posted on 2006-10-19
3
460 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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Processing of multiple cursor 6 47
Oracle - SQL Parse String 5 34
Oracle Listener Not Starting 11 44
DB migration from Mssql to 12c oracle , data not loading. 3 31
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…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.

773 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