IC77736: CONNECT BY (HIERARCHICAL) QUERY EXECUTED WITHIN STORED PROCEDURECAN LEAD TO ERROR 1214

APAR status

• Closed as fixed if next.

Error description

• A hierarchical query executed within a stored procedure can lead
  to error 1214: "Value exceeds limit of SMALLINT precision". No
  column of type SMALLINT is used in the underlying table. The
  same query executed outside a stored procedure is running
  without showing an error message.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Problem is platform independent.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Select statement with Connect by clause running within a     *
  * procedure can return a -1214 conversion error.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC10 when available.                        *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• RB50 PSN

     UP