这是我的一个插入的存储过程,不知道错在哪里,请大家帮忙看一下
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;
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;
解决方案 »
- 精通oracle函数的进来看看
- 求教下 怎么制定索引列
- 求个时间段的SQL语句(oracle的)
- 如何在同一条数据中选日期最新的字段的值?在线急等!!!!!!
- 如何不安装ORACLE客户端,正常使用PL/SQL?
- 如果你买日本汽车,将来开上中国街头的日本坦克就是你造的!!
- 请问svrmgrl是什么程序?WINDOWS2000好象没带这个程序呀?
- 求助:8.0.5 物化视图
- ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exit是进入LQLPLUS的错误提示,请问这是什么错误,急!急
- 怎样才能知道连接的是那个库呢?
- 请教oracle 升级到RAC
- ora-01219 数据库未打开:仅允许在固定的表/视图查询
SQL> show errors;
Errors for PROCEDURE RJ.LOG_INSERT:
LINE/COL ERROR
-------- ---------------------------------
12/30 PL/SQL: ORA-00984: 列在此处不允许
9/1 PL/SQL: SQL Statement ignored
v_UID in VARCHAR2,v_UNAME in VARCHAR2...你写一样的,oracle就分辨不出来
现在报这个错
SQL> show errors;
Errors for PROCEDURE RJ.LOG_INSERT:
LINE/COL ERROR
-------- ----------------------------------------------------------------------------------------------------------
18/1 PLS-00103: 出现符号 "EXCEPTION"在需要下列之一时: := . ( @ % ; 符号 ";" 被替换为 "EXCEPTION" 后继续。