FRM-40501 AND ORA-00903 STARTING FORM [message #327755] |
Tue, 17 June 2008 08:24 |
RickyGilles
Messages: 6 Registered: May 2008 Location: Milan
|
Junior Member |
|
|
I have another problem with a form. When I open that, i get the error FRM-40501. So i try to see what could be the error, displaying the visual error window, but it get me the ORA-00903: invalid table name.
Can anyone help me?
|
|
|
Re: FRM-40501 AND ORA-00903 STARTING FORM [message #327815 is a reply to message #327755] |
Tue, 17 June 2008 15:15 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
We can't help you, but you can help yourself.
Don't drop tables which are used through the application. Because, I suspect that the table existed once (or you wouldn't have been able to create and compile a form that uses invalid table name), but you (or someone else) dropped (or renamed) it.
Or, you might open a form in Forms Builder and check all table names used in PL/SQL code, block table sources, etc. The simplest way to do that would be compiling a form; compiler will return an error and point you to exact place it occurred.
|
|
|