UTL_File and UTL_SMTP packages

SOLVED
Highlighted
Adventurer

UTL_File and UTL_SMTP packages

Oracle has UTL_File and UTL_SMTP packages. I'm looking for an equivalent for  UTL_File and UTL_SMTP packages in Edb Postgres.  

Archived Discussions


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.

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
EDB Team Member

Re: UTL_File and UTL_SMTP packages

It is already available on EDB PostgreSQL.

Try \df UTL_File.* and \df UTL_SMTP.*  comand on psql prompt.

 

 

View solution in original post

Tags (2)
Highlighted
Gold Adventurer

Re: UTL_File and UTL_SMTP packages

Highlighted
Gold Adventurer

Re: UTL_File and UTL_SMTP packages

UTL_FILE.internal is "Unspecified PL/SQL error". This kind of error can be handled by using "EXCEPTION WHEN OTHERS".

View solution in original post

6 REPLIES 6
Highlighted
EDB Team Member

Re: UTL_File and UTL_SMTP packages

It is already available on EDB PostgreSQL.

Try \df UTL_File.* and \df UTL_SMTP.*  comand on psql prompt.

 

 

View solution in original post

Tags (2)
Highlighted
Adventurer

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.

Highlighted
EDB Team Member

Re: UTL_File and UTL_SMTP packages


@angie wrote:

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;

 

Highlighted
Gold Adventurer

Re: UTL_File and UTL_SMTP packages

Highlighted
Adventurer

Re: UTL_File and UTL_SMTP packages

Hi  VibhorKumar,

Thanks for the workaround for UTL_STMP exceptions such TRANSIENT_ERROR.

Is there a workaround for UTL_FILE.internal error?

 

 

                       

Highlighted
Gold Adventurer

Re: UTL_File and UTL_SMTP packages

UTL_FILE.internal is "Unspecified PL/SQL error". This kind of error can be handled by using "EXCEPTION WHEN OTHERS".

View solution in original post

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks