populate record group error

From: Diane Perkins <perkinsdt_at_navair.navy.mil>
Date: Mon, 06 Mar 2000 16:36:49 -0800
Message-ID: <38C44F21.699E9148_at_navair.navy.mil>

[Quoted] I am trying to write a proceedure to create a recordgroup based on a select statement, when I use sql-plus the select statement works, however, in the program I get the error: unable to populate the record group. Following is my code:

Declare

    group_id RecordGroup;
    query_ok NUMBER;
  BEGIN
    group_id := Create_Group_From_Query('common_group', 'SELECT role.name,

                screen.name FROM role, screen WHERE
                role.name = formCategory', GLOBAL_SCOPE);

    query_ok := Populate_Group(group_id);   IF query_ok <> 0 THEN

     RAISE FORM_TRIGGER_FAILURE;
  END IF;
  END; Thanks for any help!!
Diane Perkins
perkinsdt_at_navair.navy.mil Received on Tue Mar 07 2000 - 01:36:49 CET