Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3(EOL)
-
None
Description
Hello I tried short example to try compatibility of Oracle with MariaDB but it's not work :
sql_mode = Oracle
create or replace function ean_13(P_Str In Varchar2) Return Varchar2 Is
|
l_Sum Number;
|
l_Multiple Number;
|
Begin For I in 1..12 Loop |
If mod(i,2) = 0 Then |
l_Multiple := 3; |
Else l_Multiple := 1; |
End If;
|
l_Sum := Nvl(l_Sum, 0) + Substr(P_Str, i, 1) * l_Multiple; End Loop; |
If Floor(l_Sum/10) - Mod(l_Sum, 10) = Substr(P_Str, 13) Then Return('TRUE'); |
Else Return('FALSE'); |
End If;
|
End; /
|
Attachments
Issue Links
- duplicates
-
MDEV-10654 IN, OUT, INOUT parameters in CREATE FUNCTION
- Closed