Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle RETURN(in procedure) to HiRDB
Return in procedure converted to LEAVE.
Oracle:
RETURN ;
HiRDB:
label: BEGIN ・・・・・ [BEGIN]・・・ ・・・ LEAVE label; [END]・・・ ・・・ END
EXAMPLE:
Oracle:
CREATE PROCEDURE sp_retn1 (var float) as sText float; BEGIN sText :=1; return; END ;
HiRDB:
CREATE PROCEDURE sp_retn1 (IN var float) Swp_label1: BEGIN DECLARE sText FLOAT; SET sText = 1; LEAVE Swp_label1; END Swp_label1;