ODC version
版本号：4.3.2-1733737693000
Server: 4.3.2-20241220
Release Date: 2024-12-23
OB version
ob_last_schema_version 0
version 5.7.25-OceanBase-v4.2.1.1
version_comment OceanBase 4.2.1.1 (r101000062023103122-34e6ed68f3db97700b665a618fc3801f6b109124) (Built Oct 31 2023 22:22:10)
What happened?
希望能在ODC查询窗口中直接使用SQL语句调用存储过程或者包显示返回结果集或者值。
存储过程：
create or replace PROCEDURE PROC_TEST ( p_OpCode VARCHAR2, p_data1 OUT SYS_REFCURSOR, p_data2 OUT SYS_REFCURSOR ) AS BEGIN OPEN p_data1 FOR select p_OpCode as test FROM DUAL ; OPEN p_data2 FOR select 1 from DUAL; end;
调用语句：
DECLARE p_OpCode VARCHAR2(32767) := 'test'; p_data1 SYS_REFCURSOR; p_data2 SYS_REFCURSOR; BEGIN "PROC_TEST"(p_OpCode => p_OpCode, p_data1 => p_data1, p_data2 => p_data2); p_data1 := p_data1; p_data2 := p_data2; END;
调用结果：
What did you expect to happen?
无
How can we reproduce it (as minimally and precisely as possible)?
无
Anything else we need to know?
No response
ODC version
版本号：4.3.2-1733737693000
Server: 4.3.2-20241220
Release Date: 2024-12-23
OB version
ob_last_schema_version 0
version 5.7.25-OceanBase-v4.2.1.1
version_comment OceanBase 4.2.1.1 (r101000062023103122-34e6ed68f3db97700b665a618fc3801f6b109124) (Built Oct 31 2023 22:22:10)
What happened?
希望能在ODC查询窗口中直接使用SQL语句调用存储过程或者包显示返回结果集或者值。
存储过程：
create or replace PROCEDURE PROC_TEST ( p_OpCode VARCHAR2, p_data1 OUT SYS_REFCURSOR, p_data2 OUT SYS_REFCURSOR ) AS BEGIN OPEN p_data1 FOR select p_OpCode as test FROM DUAL ; OPEN p_data2 FOR select 1 from DUAL; end;调用语句：
DECLARE p_OpCode VARCHAR2(32767) := 'test'; p_data1 SYS_REFCURSOR; p_data2 SYS_REFCURSOR; BEGIN "PROC_TEST"(p_OpCode => p_OpCode, p_data1 => p_data1, p_data2 => p_data2); p_data1 := p_data1; p_data2 := p_data2; END;调用结果：
What did you expect to happen?
无
How can we reproduce it (as minimally and precisely as possible)?
无
Anything else we need to know?
No response