PL/SQL
ORA-06508: PL\SQL:could not find the program unit being called
I was installing the Java and the NCOMP libraries into the Oracle software home and into the DB, version 10.2.0.4. and I got the following error: ORA-04065: not executed, altered or dropped stored procedure “PUBLIC.DBMS_OUTPUT” ORA-06508: PL\SQL:could not find the program unit being called: “PUBLIC.DBMS_OUTPUT” In order to resolve this issue I ran the following: […]
PL/SQL: ORA-00942: table or view does not exist
The problem I was compiling a package with a SQL query embedded within the package body. I really couldn’t understand why the package was not compiling because the query, when run outside of the package and as the same user, was running successfully. The error that I was getting was a generic and usually very […]
ORA-06512: at “SYS.UTL_TCP”
I was developing a new package which was carrying out some maintenance processes, such as partitioning logging tables and dropping the old partitions. As part of the process, my procedure would email out the errors when running. The first stage, however, was to get the procedure to compile. I was getting the following errors: ERROR […]
ORA-06512: at line Error Messages
The ORA-06512 error message is a generic error message given to capture all PL/SQL error messages. There are multiple situations and solutions below so please read the full article. The Problem You are running a piece of PL\SQL and are receiving this message: ORA-06502 and ORA-06512: at line <line number> Note: There are multiple solutions to this […]
ORA-00904: string: invalid identifier
The Problem You have written a SQL statement and are running it from the SQL Plus command prompt and you receive the error message ORA-00904: string: invalid identifier. You may have been running an Oracle procedure, package or anonymous block of PL\SQL code and received this error. The Solution To resolve your ORA-00904 error message […]
ORA-04021: timeout occurred while waiting to lock object
You’re here because you want to resolve the ORA-04021 timeout error error. And below you will find one solution to that problem, so let’s dive straight in. The Most Likely Cause… The ORA-04021 timeout error is most likely caused by another session locking/using a package that you are attempting to execute. Personally, I came across this […]
