Target uses transformation to apply messages, and its post process throws "ORA-01405: fetches column value is null".
When target is configured to use transformation to apply the message, Post will execute the transformation procedure using OCI. If one of the dynamic variable has value null, it will through "ORA-01405: fetches column value is null".
This is an Oracle bug: 1850169.
Rewrite the stored procedure to make sure all dynamic variables will be bound with values that are not null.
The transformation procedure is an in-house procedure. In this procedure, a series of input/output will pass in the procedure, and one of the procedure variables is a dynamic variable which can be a record type or rowtype.
Note:
Oracle reported this bug has been fixed in version 10.1, but the issue happened in Oracle version 10.2.0.3 .
