Question

PLS-00306: 调用存储过程时参数个数或类型错误

创建了一个程序包 CREATE OR REPLACE Package package_getPrivileges Is Type cursor_privileges Is Ref Cursor; Procedure prc_getUserProvincePrivileges(v_account In Varchar2,v_cur Out cursor_privileges); Procedure prc_getUserCityPrivileges(v_account In Varchar2,v_cur Out cursor_privileges); Procedure prc_getUserAreaPrivilegesv_cur(v_account In Varchar2,v_cur Out cursor_privileges); Procedure prc_getUserJCJGPrivilegesv_cur(v_account In Varchar2,v_cur Out cursor_privileges); End package_getPrivileges; net调用 OracleParameter[] parames ={ new OracleParameter ("v_account" , OracleType.VarChar), new OracleParameter ("cursor_privileges", OracleType.Cursor), }; parames[0].Value = account; parames[0].Direction = ParameterDirection.Input; parames[1].Direction = ParameterDirection.Output; 错误信息： ORA-06550: 第 1 行, 第 7 列: PLS-00306: 调用 'PRC_GETUSERPROVINCEPRIVILEGES' 时参数个数或类型错误 ORA-06550: 第 1 行, 第 7 列: PL/SQL: Statement ignored

Answer 1

先试试把parames的定义稍改一下： OracleParameter[] parames ={ new OracleParameter ("v_account" , OracleType.VarChar), new OracleParameter ("v_cur", OracleType.Cursor), };