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