|
Problem IT07906
|
Status: Closed |
NULL AS CHAR(0) IS PUSHDOWN TO ORACLE FROM DB2 WHICH CAUSES ERROR ORA-01723: ZERO-LENGTH COLUMNS ARE NOT ALLOWED |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
If user is federating Oracle from db2 then db2 may generate NULL
AS CHAR(0) and push it down to oracle where its not supported.
To test this user may issues below query:
db2 "select replace ('we are here', 'are', '') from dual
below replace query is generated and pushdown to oracle where
NULL AS CHAR(0) is not supported:
REPLACE(:H0 , :H1 , CAST(NULL AS CHAR(0)))
which causes below error :
"ORA-01723: zero-length columns are not allowed " |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Anyone who encounters the error *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to db2_v105fp7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.03.2015
21.01.2016
21.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
