请在一个Oracle问题
这是我的一个插入的存储过程,不知道错在哪里,请大家帮忙看一下
create or replace procedure log_insert(UID in VARCHAR2,
UNAME in VARCHAR2,SID in VARCHAR2,LOGONTIME in DATE,
LOGOFFTIME in DATE,lIP in VARCHAR2,REMOTENAME in VARCHAR2,REMOTEUSER in VARCHAR2,
ACTIVE in CHAR,ONTIME in FLOAT,OID in VARCHAR2,OP_DATETIME in DATE,OP_CODE in VARCHAR2,
QRY_CODE in VARCHAR2,ERRID in NUMBER,ERRMSG in NVARCHAR2,msg out number) is
message number := 0;
begin
insert into xa_log_logon(USERID,USERNAME,SESSIONID,LOGONTIME,LOGOFFTIME,IP,REMOTENAME,
REMOTEUSER,ACTIVE,ONLINETIME,ORGID,OP_DATETIME,OP_CODE,QRY_CODE,ERRID,ERRMSG)
values(USERID,USERNAME,SESSIONID,LOGONTIME,LOGOFFTIME,IP,REMOTENAME,
REMOTEUSER,ACTIVE,ONLINETIME,ORGID,OP_DATETIME,OP_CODE,QRY_CODE,ERRID,ERRMSG);
message := 1;
msg := message;
exception
when others then
msg := message;
end;