Stored Procedures

How to Resolve ORA-03001: unimplemented feature

by Ed Chen
August 4, 2022September 22, 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, 2020September 11, 2022
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, 2019August 27, 2021

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 MySQL Data and Stored Procedures

by Ed Chen
March 24, 2016March 29, 2018

By default, mysqldump only backup the data from which database indicated in the command line. For stored procedures, You have to enable the backup by… Read More »