create or replace package pkg_GetDailyReport
AS
TYPE myrctype IS REF CURSOR;
PROCEDURE GetDailyReport (appeal_id in number, p_rc OUT myrctype);
END pkg_GetDailyReport; create or replace package body pkg_GetDailyReport
AS
PROCEDURE GetDailyReport (appeal_id in number, p_rc OUT myrctype)
is
strSQL varchar2(3000);
ResponseID number;
TaskID number;
begin
if appeal_id>0 then
strSQL:='SELECT id,content,fault_address FROM AR_APPEAL WHERE ID=:w_id';
open p_rc for strSQL using appeal_id;
end if;
end GetDailyReport;
end pkg_GetDailyReport;SQL 代码如上所示,请问在TOAD或SQLPlus中如何测试包里存储过程的执行结果??另外在存储过程中有number的输入参数,在C#中应该赋予什么类型的值才能匹配存储过程中参数的类型???
AS
TYPE myrctype IS REF CURSOR;
PROCEDURE GetDailyReport (appeal_id in number, p_rc OUT myrctype);
END pkg_GetDailyReport; create or replace package body pkg_GetDailyReport
AS
PROCEDURE GetDailyReport (appeal_id in number, p_rc OUT myrctype)
is
strSQL varchar2(3000);
ResponseID number;
TaskID number;
begin
if appeal_id>0 then
strSQL:='SELECT id,content,fault_address FROM AR_APPEAL WHERE ID=:w_id';
open p_rc for strSQL using appeal_id;
end if;
end GetDailyReport;
end pkg_GetDailyReport;SQL 代码如上所示,请问在TOAD或SQLPlus中如何测试包里存储过程的执行结果??另外在存储过程中有number的输入参数,在C#中应该赋予什么类型的值才能匹配存储过程中参数的类型???
plsql 右键test 输入参数 可以测试。
toad没有过、
pkg_GetDailyReport.GetDailyReport(参数1,参数2)
end;2.C#中应该赋予什么类型 oracle中number类型,包括整数,浮点数和实数。
右键 PKG_GETDAILYREPORT.GETDAILYREPORT 选择test,还要什么例子
自己去看