sqlparse
sqlparse copied to clipboard
Split does not work for REPLACE PROCEDURE
The below one REPLACE PROCEDURE is split into multiple as in screenshot
REPLACE PROCEDURE WDP1POMD_OBJECT.TYPE_DO_DELETE( P_OBJECT_TYPE_CODE VARCHAR(1)) SQL SECURITY CREATOR #MAIN# : BEGIN DECLARE GV_PACKAGE_NAME VARCHAR(50) DEFAULT 'WDP1POMD_OBJECT_TYPE'; DECLARE gv_module_name VARCHAR(50); DECLARE EXIT HANDLER FOR SQLState '02000' RESIGNAL SQLSTATE 'T7665' SET MESSAGE_TEXT = '- 20011, Record not found.'; DECLARE EXIT HANDLER FOR SQLException BEGIN CALL WDP1POMD_UTIL.omd_fatal_log2(GV_PACKAGE_NAME || '.' || GV_MODULE_NAME, SQLCODE); RESIGNAL; END; SET GV_MODULE_NAME = 'DO_DELETE';
DELETE FROM WDP1TOMD.OMD_OBJECT_TYPE WHERE OBJECT_TYPE_CODE = P_OBJECT_TYPE_CODE; END;
Which SQL dialect is this? I'm only aware of the CREATE OR REPLACE PROCEDURE
form, and adding CREATE OR
in front of the example statement works as expected.