window.repositoryObject = {"parameters_custom_fields":[],"object_id":"p384","name":"bat_cus_netpathy_mail","subtype":"PROCEDURE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"bat_cus_netpathy_mail"},{"field":"Type","value":"Procedure"}],"script":"BEGIN\r\n\tDECLARE m_err INT DEFAULT 1;\r\n    DECLARE sql_state varchar(5);\r\n    DECLARE error_no INT;\r\n    DECLARE error_msg TEXT;\r\n    \r\n    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION\r\n    BEGIN\r\n\t\tget diagnostics condition 1 sql_state=returned_sqlstate, error_no=mysql_errno, error_msg=message_text;\r\n\t\tSET m_err=0;\r\n        #ROLLBACK;\r\n    END;\r\n\r\n\tCALL cus_netpathy_mail_ins();\r\n    CALL cus_netpathy_mail_point_ins();\r\n    CALL cus_netpathy_mail_withdrawal_ins();    \r\n    \r\n    INSERT INTO EVENT_LOG(event_name, event_success, event_exec_date, event_sql_state, event_error_no, event_error_msg)\r\n\tVALUES ('bat_cus_netpathy_mail',m_err,now(),sql_state,error_no,error_msg);\r\nEND","parameters":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};