Problems with D2KHELP package 
Author Message
 Problems with D2KHELP package

    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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Problems with D2KHELP package

2. D2Khelp and Oracle8

3. Packages Run In Packages - workflow problem

4. Run a DTS package from another DTS package

5. Moving package and chaning sub package calls!

6. DTS package not executing an inside DTS package

7. Execute Package Task On Remote Server Hangs Package

8. Calling DTS package from DTS package

9. Package run correctly in dts designer, but run error when schedual this package

10. How to mass of copy large number of packages and change properties in packages

11. Package hangs unless executed on Main Package Thread

12. Suspend all other packages after 1 package fails


 
Powered by phpBB® Forum Software