Rexx/SQL / Bugs / #17 Oracle Version does not describe timestamp

#17 Oracle Version does not describe timestamp

Milestone: v1.0 (example)

Status: pending

Owner: Mark Hessling

Labels: None

Priority: 5

Updated: 2013-06-13

Created: 2007-03-23

Creator: mr_mike59

Private: No

When describing an Oracle column that is of datatype TIMESTAMP, the describe function returns UNKNOWN. Am not certain if this causes any other issues. It appears that the datatype Oracle returns for timestamp is 187.

Thanks.

Discussion

Mark Hessling - 2007-06-29

Logged In: YES
user_id=86185
Originator: NO

This is because the current Rexx/SQL for Oracle is based on the original Oracle 7 OCI, and TIMESTAMP was not a valid Oracle datatype. This will be fixed when the new Oracle interface is written using the latest OCI. This will take some time.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Mark Hessling - 2007-06-29

assigned_to: nobody --> rexx

status: open --> open-postponed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Mark Hessling - 2013-06-13

status: open-postponed --> pending

Group: --> v1.0 (example)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Mark Hessling - 2013-06-13

New port of Oracle using Oracle 8 OCI. TIMESTAMP now valid. Fixed in v2.6

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Oracle Version does not describe timestamp

An external Rexx function package to connect to SQL databases

Group

Searches

Help

#17 Oracle Version does not describe timestamp

Discussion