You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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;
The text was updated successfully, but these errors were encountered: