odc icon indicating copy to clipboard operation
odc copied to clipboard

[Bug]: Ob mysql executes stored procedure without DBMS return

Open sl01388797 opened this issue 1 year ago • 1 comments

ODC version

odc433

OB version

What happened?

image

What did you expect to happen?

image

How can we reproduce it (as minimally and precisely as possible)?

  1. Create a stored procedure in ob mysql create procedure ccgc (IN a varchar(45)) begin SET @greeting = 'Hello'; SET @name = 'Alice';

    SELECT CONCAT(@greeting, ', ', @name, '!'); end;

  2. Execute stored procedures

Anything else we need to know?

No response

sl01388797 avatar Dec 13 '24 02:12 sl01388797

Currently odc must use either out or inout declarations for stored procedures to return values

zijiacj avatar Dec 30 '24 11:12 zijiacj