MySQL Forums
Forum List  »  Stored Procedures

How to write goto stop label in mysql procedure like oracle?
Posted by: ENAMUL HAQUE
Date: July 19, 2016 06:02AM

Hello Sir,
I have user oracle procedure. But now we want to switch MySQL database with procedure. I am unable to declare stop label. Here is my oracle procedure..
how to convert MySQL procedure with stop label..

CREATE OR REPLACE PROCEDURE orap.dpr_mobiapps_reg_req_exe (
in_userid IN VARCHAR2,
out_message OUT VARCHAR2,
out_code OUT INTEGER
)
IS

BEGIN

IF in_userid IS NULL
THEN
out_code := 1;
out_message :='Please Enter Your User Id';
GOTO stop_level;
END IF;


<<stop_level>>
IF out_code = 0
THEN
COMMIT;
out_message := out_message;
ELSE
ROLLBACK;
out_code := 1;
out_message := out_message;
END IF;
END;
/

Please help me.....

Options: ReplyQuote


Subject
Views
Written By
Posted
How to write goto stop label in mysql procedure like oracle?
4403
July 19, 2016 06:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.