IZ20016: SQL0171N WHEN ISSUING A REBIND OF SQL STORED PROCEDURE PACKAGE T HAT USES LONG_VARGRAPHIC UDF

APAR status

• Closed as program error.

Error description

• Issuing the command:   db2 rebind package P12345
  may fail with the following error:
  .
  SQL0171N  The data type, length or value of argument "2" of
  routine "SYSIBM.LONG_VARGRAPHIC" is incorrect.  SQLSTATE=42815
  .
  This would happen if the package (P12345) that is being rebound
  is from an SQL Stored Procedure that uses the LONG_VARGRAPHIC
  user-defined function.
  .
  The following Table and SQL Procedure definitions would result i
  n this failure for example:
  .
  CREATE table TB1 (c1 long vargraphic)
  .
  CREATE procedure SP1 (in p1 vargraphic(16336)) language SQL
    begin
      insert into TB1 (c1) values (long_vargraphic(p1));
    end
  .
  The problem can also happen if invoking the SQL Stored Procedure
  after a dependent object was dropped.  This would cause an
  implicit rebind of the SQL Stored Procedure package, that would
  result in the SQL0171N error.
  

Local fix

Problem summary

• Users Affected:  Users rebinding SQL stored procedure packages.
  Problem Description:  The rebind (either implicit or explicit)
  of an SQL Stored Procedure package may fail with an SQL0171N
  error if the stored procedure contains the LONG_VARGRAPHIC UDF.
  

Problem conclusion

• First fixed in DB2 UDB Version 8, FixPak 17
  

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

  DB2 UDB ESE SOL

• Fixed component ID

  5765F4102

Applicable component levels

• R820 PSN

     UP