I can't compile procedure/function in SQL Developer (21.2.1.204) when COLLATE operator is used, same procedure can be compiled in SQLPlus. Is this a bug?
Example SQL Developer:
Error starting at line : 1 in command -
create or replace procedure test_proc
as
v varchar2(1);
begin
select dummy
into v
from dual
where dummy = 'x' collate binary_ci;
end test_proc;
Error report -
No more data to read from socket
Example SQLPlus:
SQL> create or replace procedure test_proc
2 as
3 v varchar2(1);
4 begin
5 select dummy
6 into v
7 from dual
8 where dummy = 'x' collate binary_ci;
9 end test_proc;
10 /
Procedure created.