DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: f90genm.sh Forms compilation Errors

  1. #1
    Join Date
    Jun 2004
    Location
    Montreal, Quebec, Canada
    Posts
    178

    Unhappy 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

  2. #2
    Join Date
    Jun 2004
    Location
    Montreal, Quebec, Canada
    Posts
    178

    Unhappy FRM-18108

    Hello,

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

    What do to about these compilation errors ?

    PT

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166

    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.

  4. #4
    Join Date
    Jun 2004
    Location
    Montreal, Quebec, Canada
    Posts
    178

    Unhappy 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

  5. #5
    Join Date
    Jun 2004
    Location
    Montreal, Quebec, Canada
    Posts
    178

    Unhappy 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

  6. #6
    Join Date
    May 2002
    Posts
    2,645
    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.

  7. #7
    Join Date
    Jun 2004
    Location
    Montreal, Quebec, Canada
    Posts
    178

    Angry 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

  8. #8
    Join Date
    Oct 2002
    Posts
    807

    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.

  9. #9
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    GRANT CONNECT, RESOURCE TO alcie;

  10. #10
    Join Date
    Jun 2004
    Location
    Montreal, Quebec, Canada
    Posts
    178

    Unhappy 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
  •  


Click Here to Expand Forum to Full Width