Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.6
-
Windows
Description
In the ORACLE-Mode there is a problem to call function and procedure in packages.
Generate the samples
SET SESSION sql_mode=ORACLE;
|
use temp;
|
|
delimiter // |
create or replace package PCK_TEST as |
procedure FUN_TEST();
|
end;
|
//
|
|
delimiter // |
create or replace package body PCK_TEST as |
|
procedure FUN_TEST() as
|
|
begin
|
select 'test-function'; |
end;
|
end;
|
|
//
|
delimiter ;
|
Following run correct:
use temp;
|
call pck_test.fun_test;
|
But when you call it with
use temp;
|
call temp.pck_test.fun_test;
|
then came the error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.fun_test' at line 1
create is this problem when you are in an other Schema
use test;
|
call temp.pck_test.fun_test;
|
There I get the same error.
I "quick and dirty" solution is:
Generate a normal function or procedure e.g. "prc_test" in the shema "temp" and in this is the call-statement "call pck_test.fun_test;". Then you can call in the Schema "test" the Function/Procedure "prc_test" in the schema "temp".
use temp;
|
|
delimiter // |
create procedure prc_test() as
|
|
begin
|
call pck_test.fun_test();
|
end;
|
//
|
delimiter ;
|
|
use test;
|
call temp.prc_test;
|
Attachments
Issue Links
- relates to
-
MDEV-19328 sql_mode=ORACLE: Package function in VIEW
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Fix Version/s | 10.4 [ 22408 ] | |
Assignee | Alexander Barkov [ bar ] |
Workflow | MariaDB v3 [ 97602 ] | MariaDB v4 [ 141343 ] |
Link |
This issue relates to |
Labels | Compatibility |
Fix Version/s | 10.9.0 [ 27113 ] | |
Fix Version/s | 10.3.35 [ 27512 ] | |
Fix Version/s | 10.4.25 [ 27510 ] | |
Fix Version/s | 10.5.16 [ 27508 ] | |
Fix Version/s | 10.6.8 [ 27506 ] | |
Fix Version/s | 10.7.4 [ 27504 ] | |
Fix Version/s | 10.8.3 [ 27502 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |