Trigger Problem, Forms 9i

From: Johnasc <news_at_news.net>
Date: Fri, 19 Mar 2004 22:46:41 -0000
Message-ID: <bKK6c.542$_r2.9_at_newsfep3-gui.server.ntli.net>



[Quoted] Hi all,

We are running Oracle forms at my University and we have a lot of configuration problems which vary from machine to machine. I cannot get the trigger below tro run (the form loads, the trigger does nothing and no error is displayed). I would appreciate it if someone could tell me if the problem lies with my trigger code or elsewhere:

The aim is to populate a listbox at runtime with the result set of a query:

DECLARE             record_group_name VARCHAR2(20) := 'Project_Numbers';

            record_group_id RecordGroup;

            error_code NUMBER;

BEGIN

  • Check that the record group hasn't already been created

            record_group_id := Find_Group(record_group_name);

  • If the record group has not already been created

            IF Id_Null(record_group_id) THEN

  • Create the record group
                        record_group_id :=
Create_Group_From_Query(record_group_name,
                                    'SELECT DISTINCT projectNo FROM
Project');

            END IF;

  • Populate the record group with records from the database

            error_code := Populate_Group(record_group_id);

  • If the query succeeded

            IF error_code <> 0 THEN

  • Clear the list of its current items, if any
                        CLEAR_LIST('PROJECTNO');

                        -- Close any open queries before populating the list

                        ABORT_QUERY();

                        -- Populate the list with the record group

                        POPULATE_LIST('PROJECTNO', record_group_id);

            END IF;

END; Thanks in advance,

Johnasc Received on Fri Mar 19 2004 - 23:46:41 CET

Original text of this message