首先,你需要在Oracle数据库中创建一个存储过程,该过程使用SYS_REFCURSOR作为输出参数。以下是一个示例存储过程: sql CREATE OR REPLACE PROCEDURE GetEmployeeData ( p_emp_id IN NUMBER, p_result OUT SYS_REFCURSOR ) AS BEGIN OPEN p_result FOR SELECT * FROM employees WHERE employee_id = p_emp_id; EN...
在Oracle中创建CR要调用的procedure,比如下面这个,注意ResultCur为输入输出类型,不能只申明为输出类型,即不能将IN OUT参数改为单单OUT型的,否则随后的CR8会无法显示这样的store procedure: procedure OperationStayTime 在CR的DataExplorer中,选择More Data Sources->Oracle Server节点,在弹出的Oracle SQL对话框中分...
In the mysql client program, for example, you can run a query, or a stored procedure that runs a query, and see the results as formatted by that program. In loose language, we could say the client has "returned" the tabular result, in the sense that it displayed it. But it has ...