ALTER TABLE
STORE_DATA 
ADD COMMENTS VARCHAR2(200);

CREATE OR REPLACE PROCEDURE UPDATE_DATA
(p_comments VARCHAR2,
p_date TIMESTAMP
) IS   
BEGIN
UPDATE STORE_DATA
SET COMMENTS = p_comments
WHERE DATA_FIELD = p_date;
END;


BEGIN
UPDATE_DATA('ABC','11-SEP-15 10.43.27.000000 PM');
END;


CREATE OR REPLACE FUNCTION FUNC_UPDATE_DATA
(
p_comments IN VARCHAR2,
p_date IN TIMESTAMP
) RETURN INTEGER
IS PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
UPDATE_DATA(p_comments,p_date);
COMMIT;
RETURN 1;
END;


SELECT FUNC_UPDATE_DATA('XYZ','11-SEP-15 10.43.27.000000 PM')
FROM DUAL;


EVALUATE('FUNC_UPDATE_DATA(%1,%2)' as CHAR, VALUEOF(NQ_SESSION."r_comments"),VALUEOF(NQ_SESSION."r_date"))