My Oracle Support Banner

Database Adapter does not recognize Timestamp column (Doc ID 396348.1)

Last updated on DECEMBER 11, 2019

Applies to:

Oracle(R) BPEL Process Manager 10g - Version 10.1.2.0.2 and later
Information in this document applies to any platform.

Symptoms

BPEL database wizard shows an error at the Select Table view:

"Some tables contain columns that are not recognized by the Database Adapter,
so they will be captured as Strings: 

My_timestamp (TIMESTAMP(9))

To fix this problem, cancel this wizard, edit the Offline Table definition to
change the type of the above columns to that of the closest supported type, and
run the Database Adapter wizard again. Please consult the Database Adapter
documentation for detailed instructions on how to fix this problem."

.

Cause

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
Symptoms
Cause
Solution


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