cancel
Showing results for 
Search instead for 
Did you mean: 

UTL_File and UTL_SMTP packages

SOLVED
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.  

Tags (2)
3 ACCEPTED SOLUTIONS

Accepted Solutions
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.

 

 

Tags (2)
EDB Team Member

Re: UTL_File and UTL_SMTP packages

Highlighted
EDB Team Member

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".

6 REPLIES
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.

 

 

Tags (2)
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.

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;

 

EDB Team Member

Re: UTL_File and UTL_SMTP packages

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
EDB Team Member

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".