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
Hi.
There is the GOOD question: how to tell Oracle receive exact type? E.g. Oracle PL/SQL function to convert a string to date is like:
to_date(a_string, 'YYYY.MM.DD');
Then how to create and pass Oracle Date Type via StoredProcedure, sure in Zope?
-- Regards, Bogdan