| 1 |
- 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"};
|
