H
hswang
Unregistered / Unconfirmed
GUEST, unregistred user!
我这样调用:call pkg_GetFunctionID.spr_GetFunctionID ('aa');
它提示调用 'SPR_GETFUNCTIONID' 时参数数量或类型错误
应该怎么写呢,还有这个过程我是要在DotNet中调用的。
如果哪位知道,请尽快相告,谢谢,在线等待!
包:
CREATE OR REPLACE PACKAGE pkg_GetFunctionID
AS
TYPE myrctype IS REF CURSOR;
PROCEDURE spr_GetFunctionID (url in varchar2, p_rc OUT myrctype);
END pkg_GetFunctionID;
包体:
CREATE OR REPLACE PACKAGE BODY pkg_GetFunctionID
AS
PROCEDURE spr_GetFunctionID (url in varchar2, p_rc OUT myrctype)
IS
sqlstr VARCHAR2 (500);
BEGIN
sqlstr :=
'select Func_ID, Func_Configure, Func_Bind, Func_BindStr
from FunctionTrees where Func_Url = :url';
OPEN p_rc FOR sqlstr USING url;
END spr_GetFunctionID;
END pkg_GetFunctionID;
它提示调用 'SPR_GETFUNCTIONID' 时参数数量或类型错误
应该怎么写呢,还有这个过程我是要在DotNet中调用的。
如果哪位知道,请尽快相告,谢谢,在线等待!
包:
CREATE OR REPLACE PACKAGE pkg_GetFunctionID
AS
TYPE myrctype IS REF CURSOR;
PROCEDURE spr_GetFunctionID (url in varchar2, p_rc OUT myrctype);
END pkg_GetFunctionID;
包体:
CREATE OR REPLACE PACKAGE BODY pkg_GetFunctionID
AS
PROCEDURE spr_GetFunctionID (url in varchar2, p_rc OUT myrctype)
IS
sqlstr VARCHAR2 (500);
BEGIN
sqlstr :=
'select Func_ID, Func_Configure, Func_Bind, Func_BindStr
from FunctionTrees where Func_Url = :url';
OPEN p_rc FOR sqlstr USING url;
END spr_GetFunctionID;
END pkg_GetFunctionID;