f90genm.sh Forms compilation Errors

Printable View

09-21-2004, 03:52 PM
ptreves

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
09-21-2004, 04:19 PM
ptreves

FRM-18108

Hello,

Also getting FRM-18108: Failed to load the following objects ?

What do to about these compilation errors ?

PT
09-21-2004, 04:28 PM
gandolf989

Re: FRM-18108

Quote:

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.
09-21-2004, 05:09 PM
ptreves

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
09-21-2004, 06:54 PM
ptreves

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
09-21-2004, 07:28 PM
stecal

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.
09-21-2004, 07:42 PM
ptreves

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
09-21-2004, 07:45 PM
Axr2

Re: YOur feedback

Quote:

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.
09-21-2004, 09:02 PM
gandolf989

GRANT CONNECT, RESOURCE TO alcie; :rolleyes:
09-21-2004, 11:50 PM
ptreves

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
09-21-2004, 11:55 PM
ptreves

GUI f90genm.sh

HEllo again,

Let me just point out that, I am usign the
GUI interface of f90genm.sh

I enter the username/password/service name + I checked the option to compile all the PL/SQL code.
-----

I noticed that the Program Units that make reference to certain tables in the database do not compile under the forms compiler.

I guess that if I grant create session or connection priviledges to the ALCIE user, I should resolve most of my forms compilation issues ??

Your toughts ?

PT
09-22-2004, 09:42 AM
gandolf989

Re: GUI f90genm.sh

Quote:

Originally posted by ptreves
I noticed that the Program Units that make reference to certain tables in the database do not compile under the forms compiler.

When this happens you should log into SQL Plus as Alcie and then do a query on user_tab_privs. This will tell you what tables you have direct privileges for. If you are missing a grant, the log in as sys and perform the grant.

Are you a developer, or just someone who is trying to make someone else's code work? If you are a developer, you should know more about how to make things work. If this is someone else's code, you should get them to help you to get it working. In the very least they should have a sql script with all of the grants that are needed to make the software work.