{"ORA-06550: 第 1 行, 第 7 列: /nPLS-00306: 调用 'NIEC_ADDUSER' 时参数个数或类型错误/nORA-06550: 第 1 行, 第 7 列: /nPL/SQL: Statement ignored/n"}

       这个问题困扰了我0.6个工作日,终于解决!

存储过程如下:

CREATE OR REPLACE PROCEDURE "NIEC_ADDUSER" --2007-5-25增加用户----〉普通
(
   Typeid   in char,
    Name     in char,
    Email    in char,
    Password in char,
    UserID   out number,
    datetime in date
)is
begin
select seq_niec_users.nextval into UserID from dual;
--select sysdate into datetime from dual;
INSERT INTO niec_users
(
    UserID,
    typeid,
    Name,
    Email,
    logintime,
    Password,
    vipsign
)
VALUES
(
    UserID,
    typeid,
    Name,
    Email,
    datetime,
    Password,
    '0'
);
select seq_niec_users.currval into UserID from dual;
end;

后台调用代码如下:

OracleConnection myConnection = new OracleConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]);
            OracleCo