红色字体为最重要的
CREATE OR REPLACE FUNCTION TESTFUC (v_dealid in number) RETURN DATE AS
pragma autonomous_transaction;
v_spmode DATE;
BEGIN
SELECT TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS') INTO v_spmode FROM DUAL;
DBMS_OUTPUT.PUT_LINE(v_spmode);
INSERT INTO TESTDT(DTTEST) VALUES(v_spmode);
commit;
RETURN v_spmode;
END ;
SELECT TESTFUC(1) FROM DUAL;