Re: Unable to fetch Timpstamp datatype using OCI layer

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

coolrohitjain_at_gmail.com wrote:
> Hi,
> I am pretty newbie to OCI layer. I was trying to make a connection to
> oracle, and was trying to fetch timestamp datatype by binding
> timpstamp datatype.
>
> This datatype shows different behavior for different sub second
> precisions.
>
> For my program(in c++) I was able to fetch data successfully for
> direct execution for both Timestamp(6) and Timestamp(9). I am able to
> see data value's.
>
> On the other hand when I was trying to bind timestamp data,
> 1) if my datatype is timestamp(6), it is unable to fetches any data.I
> also tried to insert same data using my program.
>
> 2)in case of timestamp(9), it is able to fetches only those rows which
> were inserted using my program, it doesn't fetch rows which were
> inserted using SQL-PLUS.
>
> Here I have given snippet of my code:
>
> char *sql_statement="select t1 from tstamp where t1=:1";
>

And you are absolutely sure you attempt to fetch the correct timestamp?
A timestamp(9) may fetch as 12:30:54.123456000, when inserted as timestamp(6).

• - design rule: use what you need (if timestamp(6) is sufficient, do not use (9)).
• - design rule: do not mix and match (timestamp(6) vs (9))
• - design rule: know thy data!
• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGuGquLw8L4IAs830RAraJAKCBFXt9ARGYUm9PqeIue+fkKaeyNACfZ1zV e+c34ljErDC2p85TCArAjwo=
=wZhR
-----END PGP SIGNATURE----- Received on Tue Aug 07 2007 - 07:50:54 CDT