谢谢大家的帮助,我写了个过程,可是编译有错误,该过程就是写日志表请大家帮忙
CREATE OR REPLACE PROCEDURE "SYSTEM"."" (
ALogType IN VARCHAR2,
ALogHintType IN VARCHAR2,
ALogPerson IN VARCHAR2,
ALogEvent IN VARCHAR2,
ALogData IN VARCHAR2,
ASysPamams IN VARCHAR2,
AMODCaption IN VARCHAR2)
AS
ADATE DATE;
BEGIN
SELECT SYSTEM INTO ADATE FROM dual;--取掉此句就正确了,也就是说如何
--取得当前时间并付值给变量ADATE
INSERT INTO LOGDATAINFO (LogType, LogHintType, LogPerson, LogEvent, LogData, SysPamams, MODCaption, DATETIME)
VALUES (ALogType, ALogHintType, ALogPerson, ALogEvent, ALogData, ASysPamams, AMODCaption,ADATE);
commit;
END;