The timestamp datatype is not the same as the date datatype and is new to
9i. It may well be that you need an updated ODBC driver.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Hoang C" <hoang_c_at_bls.gov> wrote in message
news:b73lmc$n2o$1_at_blsnews.bls.gov...
> This may be a possibilities. But it may not as well.
>
> Oracle TimeStamp/DateTime datatype has existed for quite sometime (since I
> can remember in Oracle 5). It has been recognized and worked with
> Powerbuilder Version 1 back in early 1992. Currently we are using
> Powerbuilder 6.5. The ODBC driver that we used for Powerbuilder is
supplied
> during Oracle 9i installation (Oracle in OraHome92). I believe that the
> Oracle driver that we used for WebLogic/Java is also supplied during
Oracle
> installation as well.
>
> Please advise.
>
> Thanks!
>
> CH
>
> "Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message
> news:3E946EAD.84F805EB_at_telusplanet.net...
> > Have your external apps been certified for Oracle9i? Some older
> applications,
> > tools and APIs will not understand the TimeStamp datatype as a
legitimate
> > Oracle datatype and will require workarounds or replacement.
> >
> > Check with your vendors both for Powerbuilder & for Java. The Java
issue
> might
> > be resolved by upgrading your JDBC library.
> >
> > /Hans
> >
>
>
Received on Thu Apr 10 2003 - 07:20:18 CDT
