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 03, 2019

Applies to:

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:

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=MYFORM_MAILTST

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:

Changes

 Migrated 11.2 database to version 12.1.0.1.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.