CREATE TABLE
STORE_DATA
(DATA_FIELD TIMESTAMP);



CREATE OR REPLACE PROCEDURE LOAD_DATA AS

BEGIN

INSERT INTO STORE_DATA (DATA_FIELD) 
VALUES(SYSDATE);

END;

BEGIN

LOAD_DATA();

END;




SELECT * FROM STORE_DATA;


CREATE OR REPLACE FUNCTION FUNC_LOAD_DATA (

p_input_value VARCHAR2
) RETURN INTEGER

IS PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN
LOAD_DATA();

COMMIT;

RETURN 1;

END;


SELECT FUNC_LOAD_DATA('Hello')

FROM DUAL;