Forms 220.127.116.11 against Oracle 18.104.22.168 DB Gets ORA-64610: Bad Depth Indicator when Using UTL_SMTP
(Doc ID 1597923.1)
Last updated on FEBRUARY 29, 2020
Applies to:Oracle Forms - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Developed forms using Oracle Forms 126.96.36.199 against a 188.8.131.52 database instance.
After migrating to a 184.108.40.206 database instance UTL_SMTP code that ran against 220.127.116.11 successfully, fails with the following error against 12.1 when attempting to send an email:
MESSAGE: smtp error ORA-64610: bad depth indicator for request 5148457
The issue can be reproduced at will with the following steps:
1. Start the Test form that sends an email:
2. Hit the "SEND EMAIL PLEASE" button to issue the email request to the database.
3. The form immediately returns MESSAGE:
v_error=User=<user>; User_Users=<user>; ORA=64610:bad depth indicator
ORA-06512: at "SYS.UTL_CALL_STACK", line 69
ORA-06512: at "SYS.UTL_TCP", line 275
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
The form calls a procedure to send an email via a stored procedure utilizing utl_smtp.
Sample Code in this Test form:
Migrated 11.2 database to version 18.104.22.168.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document