How Oracle Rename Stored Procedure
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 »How Oracle Rename Stored Procedure
Stored Procedures
GRANT EXECUTE on SYS Package to PUBLIC
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 »GRANT EXECUTE on SYS Package to PUBLIC
How to Resolve ORA-03001: unimplemented feature
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-03001: unimplemented feature
How to Resolve ORA-01031: Insufficient Privileges
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 Resolve ORA-01031: Insufficient Privileges
How to Backup PL/SQL Codes in Oracle
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 »How to Backup PL/SQL Codes in Oracle