[Zope-DB] Returning values from Oracle function/procedure withZSQLMethod

[M.-A. Lemburg]

Chris Withers wrote:
> M.-A. Lemburg wrote:
> 
>>> This is a no-go if your Oracle people go "huh? ODBC? that's deprecated
>>> rubbish and you ain't using it" ;-)
>>
>>
>> Depends on what people you're talking to, I guess...
> 
> 
> Oracle DBA's who know a helluva lot more than me about Oracle ;-)
> 
> Why are they saying ODBC is deprecated? Is it? Is ADO the way to go
> here? (as you can tell, I'm fairly clueless when it comes to MS ways
> into Oracle ;-) )

Not sure why they think that ODBC is deprecated - Oracle
is happily working on their ODBC driver and it's one
of the best bets you can find out there:

   http://www.oracle.com/technology/software/tech/windows/odbc/index.html

The only thing that's deprecated in the context of ODBC
and Oracle is the MS Oracle driver - at least that's
how things currently look (you never know with MS vs.
Oracle, e.g. they just published a new .NET provider
):

   http://support.microsoft.com/kb/q244661/

Note that ADO is just a layer on top of OLE DB and/or
ODBC and makes programming a bit easier for C++ apps
and the like. It doesn't really buy you anything
when used from Python - just adds one more layer to
worry about :-)

See the MS MDAC roadmap for more details:

   http://msdn.microsoft.com/data/mdac/default.aspx?pull=/library/en-us/dnmdac/html/data_mdacroadmap.asp

It is interesting to see things like e.g. DAO which was
en vogue a few years ago being listed as obsolete data
access technology.

>> BTW, would calling it mxOracle Zope DA help ? (just
>> testing waters here ;-)
> 
> Sadly, not in the slightest. For me, only normal oracle listeners will
> ever be available :-(

Would a native Oracle interface help ?

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Apr 19 2005)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::