ORA-00942 table or view does not exist Error in Oracle Forms

in Oracle Development and Fusion Middleware; Sir, I have facing problem in Oracle FOrms. If, I enter the password and the main menu is not working ...
+ Post Reply + Post New Topic
Results 1 to 5 of 5
  1. #1
    sakchennai is offline Junior Member
    Points: 90, Level: 1
    Join Date
    06 May 2009
    Posts
    2
    Points
    90

    ORA-00942 table or view does not exist Error in Oracle Forms

    Sir,

    I have facing problem in Oracle FOrms. If, I enter the password and the main menu is not working properly. The following errors are display.
    Code :
    Error  :  -942 ORA-00942 table or view does not exist.
     
            :   FRM-40735 Pre-Insert trigger raised unhandled exception ORA-00942.
    Please tell us how to solve the problem. Because I don't know Pl/SQL.

    Please help us


    thanking u

    anand


  2. #2
    tyro's Avatar
    tyro is offline Forum Genius
    Points: 5,680, Level: 48
    Join Date
    20 Aug 2008
    Location
    India
    Posts
    368
    Points
    5,680

    Re: ORA-00942 table or view does not exist Error in Oracle Forms

    Is the error happening when you are trying to save something from a form or just when you are logging into Forms Builder? I ask this because you are getting FRM-40735 Pre-Insert trigger raised unhandled exception ORA-00942 which means you are trying to save into a table where there is a trigger which executes before the insert.

  3. #3
    salmankhalid's Avatar
    salmankhalid is offline Forum Advisor
    Points: 2,040, Level: 27
    Join Date
    06 May 2009
    Location
    Lahore, Pakistan
    Posts
    116
    Points
    2,040

    Re: ORA-00942 table or view does not exist Error in Oracle Forms

    ORA-00902 invalid datatype

    Cause: The datatype entered in the CREATE or ALTER TABLE statement is not valid.
    Action: Correct the syntax.
    Kind Regards,
    Salman Khalid
    Software Engineer
    salmankhokhar@gmail.com

  4. #4
    APOLO_OSX2 is offline Junior Member
    Points: 20, Level: 1
    Join Date
    25 Jun 2009
    Posts
    2
    Points
    20

    Re: ORA-00942 table or view does not exist Error in Oracle Forms

    Quote Originally Posted by sakchennai View Post
    Sir,

    I have facing problem in Oracle FOrms. If, I enter the password and the main menu is not working properly. The following errors are display.
    Code :
    Error  :  -942 ORA-00942 table or view does not exist.
     
            :   FRM-40735 Pre-Insert trigger raised unhandled exception ORA-00942.
    Please tell us how to solve the problem. Because I don't know Pl/SQL.

    Please help us


    thanking u

    anand
    Hola amigo, recien he tenido el mismo problema, pero posterior me he dado cuenta cual fué mi error y es lo siguiente.

    He creado un nuevo usuario y he querido ejecutar un formulario el cual hace referencia a una tabla por ejemplo "medicos". Posteriormente de da el error frm-40735 y ora-00942.

    Bueno la causa, es que la tabla a la que hago referencia no pertenece al usuario y puedo resolverlo de dos formas:

    1.- Modificando la forma y referenciar la tabla junto con el usuario dieño de la misma así:

    factur.medicos.

    2.- La opción más práctica y si no violas la seguridad con ello, es decir crear un sinonimo publico para la tabla, de la siguiente manera:

    CREATE PUBLIC SYNONYM MEDICOS FOR FACTUR.MEDICOS

    con lo anterior, habrán eliminado los errores antes mencionados, espero que te sea de utilidad, aunque a la fecha me imagino que habrás obtenido la respuesta.

  5. #5
    simply_dba's Avatar
    simply_dba is offline Forum Advisor
    Points: 1,740, Level: 24
    Join Date
    13 Oct 2008
    Location
    Kolkata, India
    Posts
    95
    Points
    1,740

    Re: ORA-00942 table or view does not exist Error in Oracle Forms

    Ask you developer/dba to resolve this problem since you do not know pl/sql
    Some of the world's greatest feats were accomplished by people not smart enough to know they were impossible.

Other Solutions
  1. Getting Error(revision class ID already exist) while importing
    By sandeepg in forum Oracle Webcenter Suite (formerly Oracle ECM)
    Replies: 2
    Last Post: 10-22-2009, 11:02 AM
  2. Replies: 2
    Last Post: 07-18-2009, 01:01 PM
  3. Forms 10g, recording all errors happening at forms to database table
    By member.forums@gmail.com in forum Oracle Forms and Reports
    Replies: 1
    Last Post: 06-05-2009, 12:25 PM
  4. ORA-00942: table or view does not exist
    By prashant in forum SQL PL/SQL
    Replies: 3
    Last Post: 01-27-2009, 05:33 AM
  5. View all table structure in schema
    By professional in forum SQL PL/SQL
    Replies: 6
    Last Post: 12-17-2008, 05:53 AM