plsql-cop-cli icon indicating copy to clipboard operation
plsql-cop-cli copied to clipboard

Parse error when using from_vector with returning clause

Open PhilippSalvisberg opened this issue 1 year ago • 0 comments

The following example works without parse errors

select from_vector(to_vector('[1.1, 2.2, 3.3]', 3, float32));

However, when using the returning clause in from_vector a syntax error is thrown by db* CODEOP:

select from_vector(to_vector('[1.1, 2.2, 3.3]', 3, float32) returning varchar2(1000 char));
select from_vector(to_vector('[1.1, 2.2, 3.3]', 3, float32) returning clob);

PhilippSalvisberg avatar Jul 01 '24 13:07 PhilippSalvisberg