:

RSSPL/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: […]

Continue Reading

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 […]

Continue Reading

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 […]

Continue Reading

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 […]

Continue Reading

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 […]

Continue Reading

ORA-04021: timeout occurred while waiting to lock object

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 […]

Continue Reading