Re: PL/SQL & ORA-06512

Hello Jeff.

You have jumped into a known bug in PL/SQL. It has something to do with Roles/Privileges. I got the same error in simple PL/SQL-programs, if running them as a user, who IS NOT the owner. Oracle Denmark told me two days ago, that the problem is fixed in PL/SQL Version 2.0.17 (delivered with Oracle 7.0.15). Try to run the instance as the OWNER.

In article <16NOV199310364835_at_author.gsfc.nasa.gov>, chamblej_at_author.gsfc.nasa.gov (JEFF CHAMBLEE (512)) writes:
> Hello folks,
>
> I'm getting an ORA-6512 error, and it's driving me nuts.
> I'm trying to run the following through SQLPLUS. This code
> works on one of my database instances and not on another.
>
> ***********************************************************************
>
> ERROR at line 2:
> ORA-00942: table or view does not exist
> ORA-06512: at line 10
>
>
>
  Lone Aalekjær
  Datani A/S
  Copenhagen/Denmark     

>
Received on Thu Nov 18 1993 - 17:32:51 CET