ORA-00942: table or view does not exist error

Hi Sunil,

the documentation says to PLS 707 that either
- a call was made to a remote subprogram that has a parameter type or
default expression not supported at the calling site
- an incomplete upgrade or downgrade was done to a database that has
stored procedures. Perhaps incorrect versions of system packages such as STANDARD.SQL were installed.
- a compiler bug was encountered. In such cases, legal PL/SQL syntax
will fail to compile.

Action:
- revise the logic of the application to use parameter types and default
expressions that are supported at both the local and remote sites.
- complete the upgrade or downgrade properly, making sure to install
correct versions of all system packages.
- report the legal-syntax error to Oracle Customer Support. If there are
line and column numbers displayed with the error message, they might help you find a workaround. For example, try recoding the offending line to avoid the bug.

Hope that helps
Gerd Kock
www.Baltic-IT-Service.de

-----Ursprüngliche Nachricht-----
Von: Sunil Pant [mailto:spant_at_eline.com] Bereitgestellt: Donnerstag, 15. November 2001 03:42 Bereitgestellt in: server
Unterhaltung: ORA-00942: table or view does not exist error Betreff: ORA-00942: table or view does not exist error

I recently upgraded to Oracle 8.1.7 Enterprise from 8.15 in solaris 8. While creating a stored procedure I received the follwoing error.

    ORA-06553: PLS-707: unsupported construct or     internal error [2603]
Someone suggested me to run pupbld.sql in admin folder. After I ran that I
couldn't even open TOAD. Now it gives ORA-00942: table or view does not exist. But I can log in with SQLPLUS.

Please help. My develpoers use TOAD.

SP Received on Thu Nov 15 2001 - 00:50:08 CST