ptreves
asked on
menu compilation errors
Hello,
When trying to compile a Oracle menu file, I get the following errors:
=====[oracle@Linux2005 bin]$ ./f90genm.sh
Forms 9.0 (Form Compiler) Version 9.0.4.0.19 (Production)
Forms 9.0 (Form Compiler): Release - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
PL/SQL Version 9.0.1.5.0 (Production)
FRM-31605: Module /u01/app01/oracle_iAS_10g/ forms90/So urce_9i/Al cie.mmb
unknown.
ORA-00600: internal error code, arguments: [17289], [1041], [0x84ABA7C], [],
[], [], [], []
ORA-00600: internal error code, arguments: [17281], [1041], [0x84ABA7C], [],
[], [], [], []
ORA-21779: duration not active
[[oracle@Linux2005 bin]$ ./f90genm.sh
Forms 9.0 (Form Compiler) Version 9.0.4.0.19 (Production)
Forms 9.0 (Form Compiler): Release - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
PL/SQL Version 9.0.1.5.0 (Production)
FRM-31605: Module /u01/app01/oracle_iAS_10g/ forms90/So urce_9i/Al cie.mmb
unknown.
ORA-00600: internal error code, arguments: [17289], [1041], [0x84ABA7C], [],
[], [], [], []
ORA-00600: internal error code, arguments: [17281], [1041], [0x84ABA7C], [],
[], [], [], []
ORA-21779: duration not active
[desc
=====
======
[oracle@Linux2005 bin]$ ./f90genm.sh
./f90genm.sh: line 70: /u01/app01/oracleln/produc t/9.2.0.4/ bin/f90gen m: No such file or directory
[oracle@Linux2005 bin]$ ORACLE_HOME=$ORACLE_HOME2
[oracle@Linux2005 bin]$ ./f90genm.sh
Forms 9.0 (Form Compiler) Version 9.0.4.0.19 (Production)
Forms 9.0 (Form Compiler): Release - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
PL/SQL Version 9.0.1.5.0 (Production)
- Creating menu module /u01/app01/oracle_iAS_10g/ forms90/So urce_9i/Al cie.mmx.
Compiling procedure ENABLE_DISABLE_REGULAR_ITE MS...
Compilation error on procedure ENABLE_DISABLE_REGULAR_ITE MS:
PL/SQL ERROR 201 at line 3, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 3, column 5
Statement ignored
PL/SQL ERROR 201 at line 4, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 4, column 5
Statement ignored
PL/SQL ERROR 201 at line 5, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 5, column 5
Statement ignored
PL/SQL ERROR 201 at line 6, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 6, column 5
Statement ignored
PL/SQL ERROR 201 at line 7, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 7, column 5
Statement ignored
PL/SQL ERROR 201 at line 8, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 8, column 5
Statement ignored
PL/SQL ERROR 201 at line 9, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 9, column 5
Statement ignored
PL/SQL ERROR 201 at line 10, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 10, column 5
Statement ignored
PL/SQL ERROR 201 at line 11, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 11, column 5
Statement ignored
PL/SQL ERROR 201 at line 12, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 12, column 5
Statement ignored
PL/SQL ERROR 201 at line 13, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 13, column 5
Statement ignored
PL/SQL ERROR 201 at line 14, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 14, column 5
Statement ignored
PL/SQL ERROR 201 at line 15, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 15, column 5
Statement ignored
Compiling procedure ENABLE_DISABLE_QUERY_ITEMS ...
Compilation error on procedure ENABLE_DISABLE_QUERY_ITEMS :
PL/SQL ERROR 201 at line 3, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 3, column 5
Statement ignored
PL/SQL ERROR 201 at line 4, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 4, column 5
Statement ignored
PL/SQL ERROR 201 at line 5, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 5, column 5
Statement ignored
PL/SQL ERROR 201 at line 6, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 6, column 5
Statement ignored
PL/SQL ERROR 201 at line 7, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 7, column 5
Statement ignored
PL/SQL ERROR 201 at line 8, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 8, column 5
Statement ignored
PL/SQL ERROR 201 at line 9, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 9, column 5
Statement ignored
PL/SQL ERROR 201 at line 10, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 10, column 5
Statement ignored
PL/SQL ERROR 201 at line 11, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 11, column 5
Statement ignored
PL/SQL ERROR 201 at line 12, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 12, column 5
Statement ignored
PL/SQL ERROR 201 at line 13, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 13, column 5
Statement ignored
PL/SQL ERROR 201 at line 14, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 14, column 5
Statement ignored
PL/SQL ERROR 201 at line 15, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 15, column 5
Statement ignored
Compilation errors have occurred.
====
How can I resolve these menu file compilation errors ?
Your toughts ...
PT
When trying to compile a Oracle menu file, I get the following errors:
=====[oracle@Linux2005 bin]$ ./f90genm.sh
Forms 9.0 (Form Compiler) Version 9.0.4.0.19 (Production)
Forms 9.0 (Form Compiler): Release - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
PL/SQL Version 9.0.1.5.0 (Production)
FRM-31605: Module /u01/app01/oracle_iAS_10g/
unknown.
ORA-00600: internal error code, arguments: [17289], [1041], [0x84ABA7C], [],
[], [], [], []
ORA-00600: internal error code, arguments: [17281], [1041], [0x84ABA7C], [],
[], [], [], []
ORA-21779: duration not active
[[oracle@Linux2005 bin]$ ./f90genm.sh
Forms 9.0 (Form Compiler) Version 9.0.4.0.19 (Production)
Forms 9.0 (Form Compiler): Release - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
PL/SQL Version 9.0.1.5.0 (Production)
FRM-31605: Module /u01/app01/oracle_iAS_10g/
unknown.
ORA-00600: internal error code, arguments: [17289], [1041], [0x84ABA7C], [],
[], [], [], []
ORA-00600: internal error code, arguments: [17281], [1041], [0x84ABA7C], [],
[], [], [], []
ORA-21779: duration not active
[desc
=====
======
[oracle@Linux2005 bin]$ ./f90genm.sh
./f90genm.sh: line 70: /u01/app01/oracleln/produc
[oracle@Linux2005 bin]$ ORACLE_HOME=$ORACLE_HOME2
[oracle@Linux2005 bin]$ ./f90genm.sh
Forms 9.0 (Form Compiler) Version 9.0.4.0.19 (Production)
Forms 9.0 (Form Compiler): Release - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
PL/SQL Version 9.0.1.5.0 (Production)
- Creating menu module /u01/app01/oracle_iAS_10g/
Compiling procedure ENABLE_DISABLE_REGULAR_ITE
Compilation error on procedure ENABLE_DISABLE_REGULAR_ITE
PL/SQL ERROR 201 at line 3, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 3, column 5
Statement ignored
PL/SQL ERROR 201 at line 4, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 4, column 5
Statement ignored
PL/SQL ERROR 201 at line 5, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 5, column 5
Statement ignored
PL/SQL ERROR 201 at line 6, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 6, column 5
Statement ignored
PL/SQL ERROR 201 at line 7, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 7, column 5
Statement ignored
PL/SQL ERROR 201 at line 8, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 8, column 5
Statement ignored
PL/SQL ERROR 201 at line 9, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 9, column 5
Statement ignored
PL/SQL ERROR 201 at line 10, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 10, column 5
Statement ignored
PL/SQL ERROR 201 at line 11, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 11, column 5
Statement ignored
PL/SQL ERROR 201 at line 12, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 12, column 5
Statement ignored
PL/SQL ERROR 201 at line 13, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 13, column 5
Statement ignored
PL/SQL ERROR 201 at line 14, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 14, column 5
Statement ignored
PL/SQL ERROR 201 at line 15, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 15, column 5
Statement ignored
Compiling procedure ENABLE_DISABLE_QUERY_ITEMS
Compilation error on procedure ENABLE_DISABLE_QUERY_ITEMS
PL/SQL ERROR 201 at line 3, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 3, column 5
Statement ignored
PL/SQL ERROR 201 at line 4, column 5
identifier 'ENABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 4, column 5
Statement ignored
PL/SQL ERROR 201 at line 5, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 5, column 5
Statement ignored
PL/SQL ERROR 201 at line 6, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 6, column 5
Statement ignored
PL/SQL ERROR 201 at line 7, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 7, column 5
Statement ignored
PL/SQL ERROR 201 at line 8, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 8, column 5
Statement ignored
PL/SQL ERROR 201 at line 9, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 9, column 5
Statement ignored
PL/SQL ERROR 201 at line 10, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 10, column 5
Statement ignored
PL/SQL ERROR 201 at line 11, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 11, column 5
Statement ignored
PL/SQL ERROR 201 at line 12, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 12, column 5
Statement ignored
PL/SQL ERROR 201 at line 13, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 13, column 5
Statement ignored
PL/SQL ERROR 201 at line 14, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 14, column 5
Statement ignored
PL/SQL ERROR 201 at line 15, column 5
identifier 'DISABLE_ITEM' must be declared
PL/SQL ERROR 0 at line 15, column 5
Statement ignored
Compilation errors have occurred.
====
How can I resolve these menu file compilation errors ?
Your toughts ...
PT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
also a trace file would have got generated....post it here
You have used ENABLE_ITEM and DISABLE_ITEM in your code. Are these program units coded by you. What Oracle provides is SET_MENU_ITEM_PROPERTY built in ?
I think that you must open *.mmb file in a developer and see procedures ENABLE_DISABLE_REGULAR_ITE MS and ENABLE_DISABLE_QUERY_ITEMS . Maybe these procedures are part of attached library.
I did find a couple of bugs that might be related, but I need more info to decide if this is really the case. Specifically, bug 1239889 looks very similar ... and is fixed in 8.1.7.