I need a audit log of those users who are viewing the statement and others report. If users are viewing the statement all information ex : IP, username, account number, form and to date need to saving in the table.

Data has successfully inserted in the table but it's showing

191204_10550009][DATA PROCESSOR ID:81609274][SCH JOB INFO:]oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.sql.SQLException: Cannot perform fetch on a PLSQL statement: next

Function Oracle BI 12 Oracle BI Publisher 12.2.1.0.0

I called this function on OBI. Then it successfully inserted the data in table. But it is showing error. Is it possible to showing the statement data as well as parameter log in database.

CREATE OR REPLACE FUNCTION UpdateTemp(P_ACCOUNT_NO  IN STATEMENT_TEST.ac_no%TYPE,

                                      P_FROMDATE    IN STATEMENT_TEST.from_dt%TYPE,

                                      P_TODATE      IN STATEMENT_TEST.to_date%TYPE,

                                      XDO_USER_NAME IN STATEMENT_TEST.user_id%TYPE)

  RETURN BOOLEAN AS

  -- RETURN lecturer.ID%TYPE AS

BEGIN

  INSERT INTO STATEMENT_TEST

    (ac_no, from_dt, to_date, user_id, IP_ADDRESS,  Execute_date)

  VALUES

    (P_ACCOUNT_NO,

     TO_DATE(P_FROMDATE, 'DD-MON-YYYY'),

     TO_DATE(P_TODATE, 'DD-MON-YYYY'),

     (SELECT XDO_USER_NAME AS USER_ID FROM DUAL),

     (SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') IP_ADDRESS FROM dual),SYSDATE

     );

      COMMIT;

  RETURN TRUE;

EXCEPTION

  WHEN OTHERS THEN

    RETURN false;

END;