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;

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.