sqlparse icon indicating copy to clipboard operation
sqlparse copied to clipboard

Split does not work for REPLACE PROCEDURE

Open corncat-liu opened this issue 2 years ago • 1 comments

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;

Screen Shot 2022-11-26 at 8 18 11 PM

corncat-liu avatar Nov 27 '22 01:11 corncat-liu

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.

andialbrecht avatar Dec 30 '22 11:12 andialbrecht