MySQL Forums :: Stored Procedures :: How to write goto stop label in mysql procedure like oracle?


Advanced Search

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? 2686 ENAMUL HAQUE 07/19/2016 06:02AM
Re: How to write goto stop label in mysql procedure like oracle? 370 Peter Brawley 07/21/2016 06:44AM


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.