Problems with D2KHELP package

From: (wrong string) łaj Morzy <Mikolaj.Morzy_at_cs.put.poznan.pl>
Date: Sun, 9 Apr 2000 14:44:49 +0200
Message-ID: <8d1qnq$676$1_at_sunflower.man.poznan.pl>


    Hello,
I have the following problem with the D2KHELP utility. Inside the HLP_TREE package specification
there is a structure:
  TYPE rec_tree IS RECORD

       (help_level  number,
        help_id  number,
        help_title  varchar2(200),
        help_leaf  varchar2(1),
        father_id  number,
        sort_id  number);

  TYPE tab_rec is TABLE OF rec_tree INDEX BY BINARY_INTEGER;

Inside the package, in the procedure INIT_TREE there is an expression:

    tab_tree(1) := r_tree;

where tab_tree is of the type tab_rec and rec_tree is a record which is being filled with the following cursor:

    Cursor c_tree is

        select level help_level,
               help_id,
               lpad(' ',7*(level-1))||help_title help_title,
               'Y' help_leaf,
               father_id,
               sort_id
        from forms_help
        where app_name=p_app_name
        connect by prior help_id= father_id
        start with father_id is null;

The types of the relevant attributes seem OK, but when I'm trying to run the procedure INIT_TREE I get the following errors:

ERROR in line 1:

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "D2KHELP.HLP_TREE", line 78
ORA-06512: at line 4
ORA-21615: failure of the copy of an instance OTS (named or simple)
ORA-21614: constraint violation for the attribute number [1]

  • The messages are not 100% correct as I'm trying to translate them from my native language *** Of course, the documentation doesn't mention these errors. Anyone has some ideas or maybe already went through this? Thank you in advance, best regards, Mikolaj Morzy
Received on Sun Apr 09 2000 - 14:44:49 CEST

Original text of this message