Technote (troubleshooting)
Problem(Abstract)
Receiving error :
IBM InfoSphere Change Data Capture encountered an error when the
UserExit method was invoked.
A SQL exception has occurred. The SQL error code is '0'. The SQL state
is: HY000. The error message is:
[CDC][Oracle JDBC Driver]Object has been closed.
Symptom
Receiving error :
IBM InfoSphere Change Data Capture encountered an error when the
UserExit method was invoked.
A SQL exception has occurred. The SQL error code is '0'. The SQL state
is: HY000. The error message is:
[CDC][Oracle JDBC Driver]Object has been closed.
Cause
Using same stored procedure name in multiple subscriptions
Resolving the problem
The error is caused because CDC is executing derived columns with %USERFUNC
referring to the same stored procedure on different subscriptions.
The workaround that is suggested is to copy the Stored Procedure into
a different name for each subscription and then implement it in the
subscription.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.