-
f90genm.sh Forms compilation Errors
Hello,
I changed the write permission on my files and I was able to compile the libraries to plx files.
Now, my first form gives me 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.
Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
PL/SQL Version 9.0.1.5.0 (Production)
Oracle Procedure Builder V9.0.3.5.0 Build #0 - Production
Oracle Virtual Graphics System Version 9.0.1.11.0 (Production)
Oracle Multimedia Version 9.0.4.0.10 (Production)
Oracle Tools Integration Version 9.0.4.0.0 (Production)
Oracle Tools Common Area Version 9.0.2.12.0
Oracle CORE 9.0.1.2.0 Production
FRM-10043: Cannot open file.
Form not created
[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.
Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
PL/SQL Version 9.0.1.5.0 (Production)
Oracle Procedure Builder V9.0.3.5.0 Build #0 - Production
Oracle Virtual Graphics System Version 9.0.1.11.0 (Production)
Oracle Multimedia Version 9.0.4.0.10 (Production)
Oracle Tools Integration Version 9.0.4.0.0 (Production)
Oracle Tools Common Area Version 9.0.2.12.0
Oracle CORE 9.0.1.2.0 Production
Compiling function P_SHOW_ALERT...
No compilation errors.
Compiling procedure DISABLE_PRINT...
No compilation errors.
Compiling procedure ENABLE_PRINT...
No compilation errors.
Compiling procedure POPULATE_PRINT_INV...
Compilation error on procedure POPULATE_PRINT_INV:
PL/SQL ERROR 201 at line 4, column 8
identifier 'ARDETAIL' must be declared
PL/SQL ERROR 0 at line 2, column 17
SQL Statement ignored
Compiling procedure PRINT_D...
Compilation error on procedure PRINT_D:
PL/SQL ERROR 201 at line 38, column 2
identifier 'RP2RRO.RP2RRO_RUN_PRODUCT' must be declared
PL/SQL ERROR 0 at line 38, column 2
Statement ignored
Compiling procedure PRINT_COL...
Compilation error on procedure PRINT_COL:
PL/SQL ERROR 201 at line 24, column 2
identifier 'RP2RRO.RP2RRO_RUN_PRODUCT' must be declared
PL/SQL ERROR 0 at line 24, column 2
Statement ignored
Compiling procedure PRINT_STA...
Compilation error on procedure PRINT_STA:
PL/SQL ERROR 201 at line 24, column 2
identifier 'RP2RRO.RP2RRO_RUN_PRODUCT' must be declared
PL/SQL ERROR 0 at line 24, column 2
Statement ignored
Compiling procedure SURVEYOR_LIST...
No compilation errors.
Compiling procedure RECEIVABLE_LIST...
No compilation errors.
Compiling procedure DISPLAY_TOT_DUE...
Compilation error on procedure DISPLAY_TOT_DUE:
PL/SQL ERROR 201 at line 3, column 8
identifier 'ARDETAIL' must be declared
PL/SQL ERROR 0 at line 2, column 17
SQL Statement ignored
Compiling procedure SELECT_TAXENTITY...
Compilation error on procedure SELECT_TAXENTITY:
PL/SQL ERROR 201 at line 10, column 8
identifier 'TAXENTITY' must be declared
PL/SQL ERROR 0 at line 9, column 17
SQL Statement ignored
Compiling procedure SETFIELD...
No compilation errors.
Compiling procedure GET_TRXINP_T...
Compilation error on procedure GET_TRXINP_T:
PL/SQL ERROR 201 at line 9, column 13
identifier 'TBPROJECT.PROJECT' must be declared
PL/SQL ERROR 0 at line 9, column 13
Item ignored
PL/SQL ERROR 201 at line 17, column 10
identifier 'TBTRXINP' must be declared
PL/SQL ERROR 0 at line 16, column 3
SQL Statement ignored
PL/SQL ERROR 201 at line 25, column 10
identifier 'TBTRXINP' must be declared
PL/SQL ERROR 0 at line 24, column 3
SQL Statement ignored
PL/SQL ERROR 320 at line 55, column 3
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 55, column 3
Statement ignored
PL/SQL ERROR 0 at line 72, column 3
Statement ignored
Compiling function EMP_PAYRATE...
Compilation error on function EMP_PAYRATE:
PL/SQL ERROR 201 at line 4, column 8
identifier 'TBTRXINP' must be declared
PL/SQL ERROR 0 at line 3, column 18
SQL Statement ignored
Compilation errors have occurred.
Form not created
=====
1) Any ideas for these Forms compilation errors ?
(looks like I am missing some dependencies...)
PT
-
FRM-18108
Hello,
Also getting FRM-18108: Failed to load the following objects ?
What do to about these compilation errors ?
PT
-
Re: FRM-18108
Originally posted by ptreves
Hello,
Also getting FRM-18108: Failed to load the following objects ?
What do to about these compilation errors ?
PT
I'm no Forms expert. In fact I don't know Forms at all. But I would start by looking up the errors returned from the compile on Tahiti.Oracle.com, then based on the error I would fix the relevant code. When I thought I had most of the errors fixed I would compile again, and look up any additional errors that came up. To put it bluntly I would debug my code.
My guess you need to declare a bunch of stuff in your Forms.
Good luck.
-
Compilation Errors
Hello,
I made research on metalink, but I don't find it very usefull:
PL-SQL 0
PL-SQL 201
PL-SQL 320
PL-SQL 364
-----
FRM-18108
-----
FRM-30436
FRM-30064
FRM-00942
FRM-30085
Any ideas ?
PT
-
Compilation Errors
Hello Veena,
I noticed that the compilation errors are related to Program Units inside my forms concerning certain tables. After verification, I do confirm that the tables have been correctly imported in my Oracle 9i Database and do contain data.
I am at a loss to understand these and correct these compilation errors ?
Please advice ...
PT
-
Look at the syntax for running f90genm (includes username/password@SID and module name/type). If you had tried this using Form Builder (without having logged on), you'd get the same errors.
-
YOur feedback
Hello,
My database contains 1 user called ALCIE.
I imported the data as SYSTEM/MANAGER1, the sysdba.
Maybe user ALCIE does not have full rights on cerrtian tables.
ORA-01045: User ALCIE does not have Create Session rights.
How can I give user ALCIE connections right on a Database ?
PT
-
Re: YOur feedback
Originally posted by ptreves
ORA-01045: User ALCIE does not have Create Session rights.
How can I give user ALCIE connections right on a Database ?
PT
Boy, you're one heck of a lazy person. Are you new to the internet altogether? Search for GRANT.
Error: ORA 1045
Text: user lacks CREATE SESSION privilege;
logon denied ------------------------------------------------------------------------------- Cause: An attempt was made to connect to a userid that does not have create session privilege. Action: If required, GRANT the user the CREATE SESSION privilege.
-
GRANT CONNECT, RESOURCE TO alcie;
-
SP2-0460
Hello,
I did try somethin like that:
grant create session to alcie;
I get a strange error:
SP2-0460
1) What is that about ?
Your toughts ?
PT
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|