Re: populate record group error

From: <pberetta_at_my-deja.com>
Date: Tue, 07 Mar 2000 10:40:50 GMT
Message-ID: <8a2mbi$dfg$1_at_nnrp1.deja.com>

Diane,

[Quoted]    Just a guess, but if 'formCategory' is a quoted string in your command line SQL*Plus, then this might solve your problem: Declare
  group_id RecordGroup;
  query_ok NUMBER;
  v_role_name VARCHAR2(11) := 'formCategory'; BEGIN
  group_id := Create_Group_From_Query('common_group',

             'SELECT role.name, screen.name
              FROM   role, screen
              WHERE  role.name = v_role_name',

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

     RAISE FORM_TRIGGER_FAILURE;
  END IF;
END; Regards,
Paul

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Mar 07 2000 - 11:40:50 CET