Stored Procedures

How to Resolve ORA-01031 for EXECUTE IMMEDIATE in Store Procedures

by Ed Chen
June 24, 2020June 26, 2020

ORA-01031 Let's see how I reproduce ORA-01031 for statements using EXECUTE IMMEDIATE by the following example. First of all, I create a role for a… Read More »

How to Take Backup of Stored Procedure in Oracle

by Ed Chen
September 11, 2019November 8, 2019

Backup of Stored Procedure Usually, source codes of programming unit should be version-controlled by the developer team. But if they have never carried out their… 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 »