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 17, 2014

Applies to:

Oracle Forms - Version 11.1.2.1.0 and later
Information 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:

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

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