以下是我执行的过程,请高手帮帮忙! 1 create or replace procedure loginfo_login
2 (v_operatorid number,v_logintime timestamp,v_valid number,v_logofftime timestamp,v_ip varchar
3 as
4 p_operatorid number:=v_operatorid;
5 p_logintime timestamp:=v_logintime;
6 p_valid number:=v_valid;
7 p_logofftime timestamp:=v_logofftime;
8 p_ip varchar2(50):=v_ip;
9 p_reason varchar2(50):=v_reason;
10 begin
11 insert into loginfo
12 (operatorid,lgointime,valid,logofftime,ip,reason)
13 values
14 (p_operatorid,p_lgointime,p_valid,p_logofftime,p_ip,p_reason);
15 commit;
16* end;警告: 创建的过程带有编译错误。SQL> show error
PROCEDURE LOGINFO_LOGIN 出现错误:LINE/COL ERROR
-------- -----------------------------------------------------------------
11/3 PL/SQL: SQL Statement ignored
14/20 PL/SQL: ORA-00984: 列在此处不允许
2 (v_operatorid number,v_logintime timestamp,v_valid number,v_logofftime timestamp,v_ip varchar
3 as
4 p_operatorid number:=v_operatorid;
5 p_logintime timestamp:=v_logintime;
6 p_valid number:=v_valid;
7 p_logofftime timestamp:=v_logofftime;
8 p_ip varchar2(50):=v_ip;
9 p_reason varchar2(50):=v_reason;
10 begin
11 insert into loginfo
12 (operatorid,lgointime,valid,logofftime,ip,reason)
13 values
14 (p_operatorid,p_lgointime,p_valid,p_logofftime,p_ip,p_reason);
15 commit;
16* end;警告: 创建的过程带有编译错误。SQL> show error
PROCEDURE LOGINFO_LOGIN 出现错误:LINE/COL ERROR
-------- -----------------------------------------------------------------
11/3 PL/SQL: SQL Statement ignored
14/20 PL/SQL: ORA-00984: 列在此处不允许
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货