Stored Procedures

How to Resolve ORA-01031: Insufficient Privileges

by Ed Chen
June 24, 2020June 18, 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 »