My Oracle Support Banner

Database Change Notifications - JDBC Driver Returns Question Marks (???) Instead Of TableName (Doc ID 1553808.1)

Last updated on MAY 17, 2013

Applies to:

JDBC - Version and later
Information in this document applies to any platform.


When using Database Change Notifications, notifications are not received and table registrations are not seen for notifications in the USER_CHANGE_NOTIFICATION table.
In spite of the user being successfully granted change notification, the firewall port is open between client server and the database server. and the client host IP and port number are included during initial registration, the issue is observed.

Logs show TableName as ??? :

2013-04-14 16:10:18.103 [INFO] Thread-3 - RegId: 36
2013-04-14 16:10:18.103 [INFO] Thread-3 - DatabaseName: SIDE
2013-04-14 16:10:18.104 [INFO] Thread-3 - TableName: ???
2013-04-14 16:10:18.104 [INFO] Thread-3 - ObjectNumber: 103178
2013-04-14 16:10:18.104 [INFO] Thread-3 - RowId: AAAmNpADpAAAbYpAAC
2013-04-14 16:10:18.105 [INFO] Thread-3 - RowOperation: INSERT

Issue is seen with WE8ISO8859P15 database NLS_CHARACTERSET. The same code works fine with: AL32UTF8, WE8ISO8859P1, WE8MSWIN1252 character sets.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.