I'm looking for UTL_SMTP Exceptions like UTL_SMTP. TRANSIENT_ERROR or UTL_SMTP. PERMANENT_ERROR in EDB Postgres.
I am not sure what are these errors and when will be thrown.
I think its worth to see what is exactly behaviour in EDB Postgres and what is error code thrown using 'WHEN OTHERS ' as follow, and check errorcode name in PostgreSQL Error Codes document :
DECLARE <some declaration> BEGIN <some code> <some code> EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('SQLERRM: ' || SQLERRM); DBMS_OUTPUT.PUT_LINE('SQLCODE: ' || SQLCODE); END;
Thanks for the workaround for UTL_STMP exceptions such TRANSIENT_ERROR.
Is there a workaround for UTL_FILE.internal error?