1. The Forum has been upgraded to a modern and advanced system. Please read the announcement about this update.
  2. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'Oracle Forms and Reports' started by sakchennai, May 6, 2009.

  1. sakchennai

    sakchennai Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    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 (Text):

    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. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    18
    Trophy Points:
    260
    Location:
    India
    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. salmankhalid

    salmankhalid Forum Advisor

    Messages:
    116
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Lahore, Pakistan
    ORA-00902 invalid datatype

    Cause: The datatype entered in the CREATE or ALTER TABLE statement is not valid.
    Action: Correct the syntax.
     
  4. APOLO_OSX2

    APOLO_OSX2 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    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. simply_dba

    simply_dba Forum Advisor

    Messages:
    95
    Likes Received:
    5
    Trophy Points:
    140
    Location:
    Kolkata, India
    Ask you developer/dba to resolve this problem since you do not know pl/sql