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

Parse error when using vector_serialize with returning clause

Open PhilippSalvisberg opened this issue 1 year ago • 0 comments

The following example work without parse errors

select vector_serialize(vector('[1.1,2.2,3.3]', 3, float32));

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

select vector_serialize(vector('[1.1,2.2,3.3]', 3, float32) returning varchar2(200 char));
select vector_serialize(vector('[1.1,2.2,3.3]', 3, float32) returning clob);

PhilippSalvisberg avatar Jul 01 '24 12:07 PhilippSalvisberg