IBM Support

IT03568: ORACLE DSO CONNECTIONS FROM DATAPOWER MIGHT FAIL IF MULTIPLE PACKAGES HAVE IDENTICAL PROCEDURE NAMES WITHIN ORACLE DATABASE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using SQL-Execute from DataPower with any Oracle Data
    Source Object connection to make a Stored Procedure call, the
    following error might occur:
    'numeric or value error:  character string buffer too small'.
    
    This occurs only when the procedure is located in one package,
    and the procedure name is located in another Package that is
    accessible to the DSO defined user.
    

Local fix

  • Ensure that all Procedure Names, regardless of the package
    they are included in, have unique names. This will ensure no
    procedure conflicts occur.
    

Problem summary

  • If multiple packages include the same stored procedure name, the
     database error 'ORA-06502: PL/SQL: numeric or value error:
    character string buffer too small' may be returned if the store
    procedure is called.
    This symptom occurred on a store procedure called using Oracle
    JDBC Driver.
    
    These are following forms expected in the style sheet:
        . CALL <stored proc name>
        . CALL <schema (or userid)>.<stored proc name>
        . CALL <schema (or userid)>.<catalog (or package)>.<stored
    proc name>
    
    In particular, note that the following is not supported by
    Oracle Driver:
        . CALL <catalog (or package)>.<stored proc name>
    
    So if specifying the catalog name, the schema name needs to be
    specified as well.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT03568

  • Reported component name

    DATAPOWER

  • Reported component ID

    DP1234567

  • Reported release

    500

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-08-04

  • Closed date

    2014-10-30

  • Last modified date

    2014-11-20

  • 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

    DATAPOWER

  • Fixed component ID

    DP1234567

Applicable component levels

  • R601 PSY

       UP

  • R700 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCXUFY","label":"General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.0.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
20 November 2014