Stored Procedures

How to Resolve ORA-04050: invalid or missing procedure, function, or package name

by Ed Chen
May 19, 2023May 26, 2023

ORA-04050 Tried to create a stored procedure, i.e. procedure, function or package, but it failed with ORA-04050. Reserved Word SQL> create procedure audit; 2 … Read More »

How Oracle Rename Stored Procedure

by Ed Chen
October 12, 2022November 17, 2022

No, you cannot simply rename a function, package or procedure by an ALTER statement, there's no such syntax to support this. All you can do… Read More »

GRANT EXECUTE on SYS Package to PUBLIC

by Ed Chen
August 13, 2022April 27, 2023

We used the following SQL statement to retrieve and compose necessary GRANT statements for you to fix your compiler problems related to SYS's public packages,… Read More »

How to Resolve ORA-03001: unimplemented feature

by Ed Chen
August 4, 2022October 6, 2022

ORA-03001 Tried to use RENAME TO statement to rename a schema object, but it failed with ORA-03001. SQL> rename add_job_history to add_job_history_all; rename add_job_history to… Read More »

How to Resolve ORA-01031: Insufficient Privileges

by Ed Chen
June 24, 2020June 6, 2023
1 Comment

ORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »

How to Backup PL/SQL Codes in Oracle

by Ed Chen
September 11, 2019June 6, 2023

Backup Packages and Procedures Usually, source codes of programming unit should be version-controlled by the developer team. Mostly, they use Git, CVS or SVN to… Read More »

JavaScript is not enabled. Please enable it and reload the page.