Script to Debug in PL/SQL (Store in custom table)

 CREATE TABLE ora_debug_logs (
  error_message  VARCHAR2(4000)
);
CREATE OR REPLACE PROCEDURE ora_log_proc (p_error_message  IN  VARCHAR2) AS
  PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
  INSERT INTO ora_debug_logs (error_message)
  VALUES (p_error_message);
  COMMIT;
END;
/