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 A Law of Computer Programming: Make it possible for programmers to write in English and you will find that programmers cannot write in English.
sorry Bogdan, I might be able to help out here, but I don't understand the question. read your own sig ;) Bo M. Maryniuck wrote:
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?
On Thursday 07 November 2002 20:19, Ben Avery wrote:
sorry Bogdan, I might be able to help out here, but I don't understand the question. read your own sig ;)
;-) Ah. This is shoud go to the Zope DB. Sorry. -- Regards, Bogdan This sentence does in fact not have the property it claims not to have.
there's a Zope DB list? cool! where? Bo M. Maryniuck wrote:
On Thursday 07 November 2002 20:19, Ben Avery wrote:
sorry Bogdan, I might be able to help out here, but I don't understand the question. read your own sig ;)
;-) Ah. This is shoud go to the Zope DB. Sorry.
found it, sorry. cripes! there's loads of them, thought this and zope-dev were the only ones :-) ben@thesite.org wrote:
there's a Zope DB list? cool! where?
Bo M. Maryniuck wrote:
On Thursday 07 November 2002 20:19, Ben Avery wrote:
sorry Bogdan, I might be able to help out here, but I don't understand the question. read your own sig ;)
;-) Ah. This is shoud go to the Zope DB. Sorry.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
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
participants (3)
-
Ben Avery -
Bo M. Maryniuck -
Charlie Reiman