Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FRM-93652 The runtime process has terminated abnormally in Forms 12c

KalpataruMay 8 2016 — edited May 10 2016

Hi All,

I have used the below code for populating a tree item, but when i run the below code it throws the

error FRM-93652 The runtime proess has terminated abnormally.

DECLARE

  rgTree  RECORDGROUP;

  vcQuery VARCHAR2(2000);

  nStatus NUMBER;

  itTree  ITEM := FIND_ITEM ('BLOCK_TREE.TREE_EMPLOYEE');

BEGIN

  rgTree := FIND_GROUP ('RG_TREE');

 

  IF Id_Null(rgTree) THEN

     rgTree := Create_Group('RG_TREE');

  END IF;

  -- Clear Tree

  Ftree.DELETE_TREE_NODE (itTree, Ftree.ROOT_NODE);

  -- Build up a new Query, if desired

  vcQuery := 'SELECT -1 as NODE_STATE,LEVEL as NODE_DEPTH,ENAME as NODE_LABEL,

                           DECODE(LEVEL,1,''insrec'',''nxtblk'') as NODE_ICON,

                           To_Char(EMPNO) as NODE_VALUE

                FROM EMP CONNECT BY PRIOR EMPNO=MGR

               START WITH MGR IS NULL

               ORDER SIBLINGS BY ENAME';

  -- Repopulate Record-Group

  nStatus := POPULATE_GROUP_WITH_QUERY (rgTree, vcQuery);

  -- Repopulate Tree

  Ftree.POPULATE_TREE(itTree);

END;

What and where is the problem with this code.

How to solve this issue ?

This post has been answered by Andreas Weiden on May 9 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2016
Added on May 8 2016
16 comments
7,061 views