Forms 184.108.40.206 against Oracle 220.127.116.11 DB Gets ORA-64610: Bad Depth Indicator when Using UTL_SMTP
Last updated on FEBRUARY 17, 2014
Applies to:Oracle Forms - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Developed forms using Oracle Forms 22.214.171.124 against a 126.96.36.199 database instance.
After migrating to a 188.8.131.52 database instance UTL_SMTP code that ran against 184.108.40.206 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=SCOTT; User_Users=SCOTT; 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 220.127.116.11.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms