odc icon indicating copy to clipboard operation
odc copied to clipboard

[Bug]: some procedure's parameters can not be displayed

Open runzi389205 opened this issue 2 years ago • 0 comments

ODC version

4.2.1

OB version

mysql mode 4.1.0

What happened?

-- create pl object   

create procedure `exec_sql` (IN `v` varchar(4000)) begin  
  declare continue handler for sqlexception  
  begin  
    GET DIAGNOSTICS CONDITION 1 @p1 = RETURNED_SQLSTATE, @p2 = MESSAGE_TEXT;  
  end;  
  set @sql_text = v;  
  prepare stmt from @sql_text;  
  execute stmt;  
  deallocate prepare stmt;  
end;  
/

-- display In pl list, displays this object.

The parameters of the exec object in the list are not displayed

What did you expect to happen?

can be view parameters of pl

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

Anything else we need to know?

Cloud

runzi389205 avatar Sep 05 '23 03:09 runzi389205