Effective March 31st, we will no longer engage on PostgresRocks.
How to engage with us further?
- Thought Leadership: EDB Blogs
- Tips and Tricks: Postgres Tutorials
- Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket
- Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.
Re: UTL_File and UTL_SMTP packages
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;