Forms 11.1.2.1 against Oracle 12.1.0.1 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 11.1.2.1.0 and laterInformation in this document applies to any platform.
Symptoms
Developed forms using Oracle Forms 11.1.2.1 against a 11.1.0.2 database instance.
After migrating to a 12.1.0.1 database instance UTL_SMTP code that ran against 11.1.0.2 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
STEPS
The issue can be reproduced at will with the following steps:
1. Start the Test form that sends an email:
http://<hostname:port>/forms/frmservlet?form=formname
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:
Changes
Migrated 11.2 database to version 12.1.0.1.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |