Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.6
-
None
-
Windows
Description
In the ORACLE-Mode there is a problem to call function and procedure with "=>"
Generate the samples
use test;
|
SET SESSION sql_mode='ORACLE,EMPTY_STRING_IS_NULL'; |
|
|
delimiter // |
create or replace procedure test_proc(p1 varchar2, p2 varchar2, p3 varchar2) as
|
|
|
v1 varchar2(100); |
|
|
begin
|
v1:=p1;
|
end;
|
//
|
|
|
delimiter ;
|
When I call this with
call test_proc('xxx','yy','zz'); |
Then the code will be run correctly.
but, when I call this with "=>" then I get an error.
call test_proc(p1=>'xxx', p2=>'aa', p3=>'yy'); |
ERROR 1054 (42S22): Unknown column 'p1' in 'field list' |
|
|
call test_proc('xxx', p2=> 'aa', p3 => 'yy'); |
ERROR 1054 (42S22): Unknown column 'p2' in 'field list' |
|
|
call test_proc('xxx', p3=> 'aa', p2 => 'yy'); |
ERROR 1054 (42S22): Unknown column 'p3' in 'field list' |