Error ICRG-102 while creating Recordgroup in Oracle-Forms

From: Jens Hartwig <jhartwig_at_debis.com>
Date: Mon, 17 Apr 2000 16:42:03 +0200
Message-ID: <38FB22BB.2302771E_at_debis.com>

Hello all,

I have a big problem with Forms 4.5, Version 4.5.7.15.3 (Production), 16 Bit, working against Oracle 8.1.5:

When I use the built-in-function CREATE_GROUP_FROM QUERY with a statement which contains a stored function (which is defined with PRAGMA RESTRICT_REFERENCES (..., WNDS)), I get the following error:

"Oracle Forms 4.5: unhandled error in icrg 102"

The code is given below!

When I use an Oracle 7.3.4 database with exactly the same function, it works. Does anybody has an idea?

Thank you very much for spending your valuable time!

Best regards, Jens

---

1. Package/Function:

   ---

   CREATE OR REPLACE package sk_Test is FUNCTION test RETURN VARCHAR2; PRAGMA RESTRICT_REFERENCES(test, WNDS, RNDS, WNPS, RNPS, TRUST ); end sk_Test;

CREATE OR REPLACE PACKAGE BODY sk_Test IS

    FUNCTION test RETURN VARCHAR2 IS
    BEGIN
        RETURN 'test';
    END;
END;
/

---

2. Forms-Procedure:

---

DECLARE
  lv_rg_id RECORDGROUP;
  lv_statement VARCHAR2(100);
BEGIN
  lv_statement := 'SELECT diwo.sk_Test.test FROM dual';   lv_rg_id := CREATE_GROUP_FROM_QUERY('TMP_EXEC', lv_statement);   DELETE_GROUP(lv_rg_id);
END;

---

---

Jens Hartwig

---

debis Systemhaus GEI mbH
10875 Berlin

Tel.     : +49 (0)30 2554-3282
Fax      : +49 (0)30 2554-3187
Mail     : jhartwig_at_debis.com


=============================================

Please consider: The statements expressed in this mail do represent the authors opinion and are not necessarily identical with those of debis Systemhaus GEI.

---

Received on Mon Apr 17 2000 - 16:42:03 CEST