IT09218: TEXT OF RAISE EXCEPTION IN STORED PROCEDURE TRUNCATED AFTER 72 C HARACTERS AND CONTAINING UNEXPECTED CHARACTERS IN THE TRACE FILE

APAR status

• Closed as program error.

Error description

• When you are using an error text in a RAISE EXCEPTION statement
  within a stored procedure this text is truncated after 72
  characters when it is returned as error message to the client.
  
  If you have activated stored procedure tracing the debug file
  content will contain unexpected characters in the message text
  after the first 72 characters of the error message.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Making use of specific error -746 for stored procedures in   *
  * order to utilize user supplied error message specified in    *
  * the stored procedure.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC6 or newer.            *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC6 or newer.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RC10 PSY

     UP