Re: Problem with execution of script in different instances of Oracle
Date: 4 Oct 1994 09:50 -0500
Message-ID: <4OCT199409503068_at_author.gsfc.nasa.gov>
In article <36pro6$ams_at_aplcomm.jhuapl.edu>, kamu_pindiprolu_at_jhuapl.edu (Kamu) writes...
>Hi
>
>I am running a PL/SQL procedure in Oracle 7 in one of the financials
>modules. I received an error ORA-6512 at line 1 of my code.
>The program contains cursors, procedures and dbms_output statements.
>I don't have all the manuals but if you could provide the text description for the
>error message or if you have come across this error please provide
>some insight.
>
>Thanks in advance
>Kamu
Ahhhhhh! The DREADED ORA-06512! I wasted UNBELIEVABLE hours on that one last November.
Path: skates.gsfc.nasa.gov!ames!elroy.jpl.nasa.gov!swrinde!cs.utexas.edu!howland.reston.ans.net!pipex!sunic!trane.uninett.no!news.eunet.no!nuug!dkuug!datani!la From: la_at_datani.dk
Newsgroups: comp.databases.oracle
Subject: Re: PL/SQL & ORA-06512
Message-ID: <1993Nov18.173251.121_at_datani.dk> Date: 18 Nov 93 17:32:51 +0100
References: <16NOV199310364835_at_author.gsfc.nasa.gov> Distribution: world
Organization: Datani A/S, Copenhagen, Denmark Lines: 32
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
>
By the way, I'm a student at JHU APL.
Jeff Chamblee
Computer Sciences Corp.
1100 West Street
Laurel, MD 20707
Received on Tue Oct 04 1994 - 15:50:26 CET