[Zope] Data types in Stored Procedures

[Charlie Reiman]

I'm not entirely sure what you're asking, but I never pass dates to =
Oracle anymore. I convert my dates to strings, then use to_date on =
oracle where ever I need a date. In fact, we generally avoid using date =
types in oracle and just use a consistent date string format (YYYYMMDD) =
which sorts nicely and simplifies DB communication.


> -----Original Message-----
> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Bo =
M.
> Maryniuck
> Sent: Thursday, November 07, 2002 10:16 AM
> To: zope@zope.org
> Cc: Matthew T. Kromer
> Subject: [Zope] Data types in Stored Procedures
>=20
>=20
> Hi.
>=20
> There is the GOOD question: how to tell Oracle receive exact=20
> type? E.g. Oracle=20
> PL/SQL function to convert a string to date is like:
>=20
> 	to_date(a_string, 'YYYY.MM.DD');
>=20
> Then how to create and pass Oracle Date Type via StoredProcedure, sure =
in=20
> Zope?
>=20
> --=20
> Regards, Bogdan=20