Error when using Connect By in record group in Forms 4.5

From: Gary Mason <garym_at_INTONET.CO.UK>
Date: Sun, 7 Jan 1996 14:10:01 -0500
Message-Id: <9601072107.AA09120@alice.jcc.com>

We are trying to create a record group using a connect by.. start with clause in the query. This causes an Oracle error (details below) and eventually a GPF. The error number is different depending on whether we try to populate a group from query or create a query record group. We can't find anything in the manuals that says this can't be done, but if we omit this clause it works fine. The query (without the group creation) has been tested in SQL*Plus, and this works fine. Does anyone have any ideas?

The procedures are as follows (sorry about the length of this).   The following procedure produces the error 41076 when trying to populate   the group, and shortly afterwards G.P.F's with the message

  F45RUN caused a GPF in module F45R.DLL at 001D:4F5E

  PROCEDURE create_rg_down_tree (prm_rec_grp_name IN VARCHAR2,

                    prm_asgrp_type IN INTEGER,
                    prm_asgrp_id IN VARCHAR2) IS

   rg_id       RecordGroup;
   rg_pop      Integer;

  BEGIN     rg_id := FIND_GROUP (prm_rec_grp_name);

    IF NOT ID_NULL (rg_id) THEN
      DELETE_GROUP (rg_id);
    END IF;     rg_id := CREATE_GROUP ( prm_rec_grp_name );

    rg_pop := POPULATE_GROUP_WITH_QUERY( rg_id ,

      ' SELECT  pag.group_name, pag.asset_group_id '

||' FROM pds_asset_groups pag '
||' WHERE pag.asset_group_type = ' || to_char (prm_asgrp_type)
||' CONNECT BY pag.parent_asset_group_id = PRIOR asset_group_id '
||' START WITH pag.asset_group_id ' || prm_asgrp_id );

  END;

---

  The following procedure produces the error 41072 when trying to   create the group.

  PROCEDURE create_rg_down_tree (prm_rec_grp_name IN VARCHAR2,

                    prm_asgrp_type IN INTEGER,
                    prm_asgrp_id IN VARCHAR2) IS

   rg_id       RecordGroup;
   rg_pop      Integer;

  BEGIN     rg_id := FIND_GROUP (prm_rec_grp_name);     IF NOT ID_NULL (rg_id) THEN
      DELETE_GROUP (rg_id);
    END IF;     rg_id := CREATE_GROUP_FROM_QUERY ( prm_rec_grp_name,

         ' SELECT pag.group_name, pag.asset_group_id '
||' FROM pds_asset_groups pag '
||' WHERE pag.asset_group_type = ' || to_char (prm_asgrp_type)
||' CONNECT BY pag.parent_asset_group_id = PRIOR asset_group_id '
||' START WITH pag.asset_group_id ' || prm_asgrp_id );

    rg_pop := POPULATE_GROUP( rg_id );

  END; TIA Gary Mason (garym_at_intonet.co.uk) Received on Sun Jan 07 1996 - 16:07:37 CST