Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Chris Withers wrote: > M.-A. Lemburg wrote: > >> We won't have anything ready in the next three months; >> that much I can tell you. >> >> If you make DCOracle2 stable enough to use as low-level >> interface, we might even consider using DCOracle2 for >> the Zope DA, so we wouldn't want to hold you off on fixing >> issues in DCOracle2 :-) > > Heh, in three months time I'm likely to have released a stable version > of ZOracleDA AND DCOracle2 ;-) We'll see... -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Apr 28 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 ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
M.-A. Lemburg wrote: We won't have anything ready in the next three months; that much I can tell you. If you make DCOracle2 stable enough to use as low-level interface, we might even consider using DCOracle2 for the Zope DA, so we wouldn't want to hold you off on fixing issues in DCOracle2 :-) Heh, in three months time I'm likely to have released a stable version of ZOracleDA AND DCOracle2 ;-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Chris Withers wrote: > M.-A. Lemburg wrote: > >>> Huh? I think you need to provide a little more information there... >> >> >> >> Sorry, I meant that the "native Oracle interface" is not DCOracle2, >> hinting that at the project I mentioned below. > > right, but DCOracle2 is *A* native oracle interface, right? No doubt about that :-) We're considering working on one of these. It is not clear yet whether we'd just hook up on one of the existing Oracle interfaces or invent our own. >>> >>> >>> Tell me more :-) >> >> >> Nothing much to tell yet - we're currently busy with other >> products, but the above idea is in the queue. > > How will it be different to DCOracle2 and how far along with it are you? > I have imminently in my stack fixing a number of DCOracle2 issues and > getting a release or three out, and if I don't need to do that, I'd like > to know now ;-) We won't have anything ready in the next three months; that much I can tell you. If you make DCOracle2 stable enough to use as low-level interface, we might even consider using DCOracle2 for the Zope DA, so we wouldn't want to hold you off on fixing issues in DCOracle2 :-) -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Apr 22 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 ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
M.-A. Lemburg wrote: Huh? I think you need to provide a little more information there... Sorry, I meant that the "native Oracle interface" is not DCOracle2, hinting that at the project I mentioned below. right, but DCOracle2 is *A* native oracle interface, right? We're considering working on one of these. It is not clear yet whether we'd just hook up on one of the existing Oracle interfaces or invent our own. Tell me more :-) Nothing much to tell yet - we're currently busy with other products, but the above idea is in the queue. How will it be different to DCOracle2 and how far along with it are you? I have imminently in my stack fixing a number of DCOracle2 issues and getting a release or three out, and if I don't need to do that, I'd like to know now ;-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Chris Withers wrote: > M.-A. Lemburg wrote: > Would a native Oracle interface help ? >>> >>> >>> Yeah, and that's what DCOracle2 is, right? >> >> >> Nope. > > > Huh? I think you need to provide a little more information there... Sorry, I meant that the "native Oracle interface" is not DCOracle2, hinting that at the project I mentioned below. >>> If you're telling me you have a real live decent quality native oracle >>> interface, then I'm all ears :-) >> >> >> We're considering working on one of these. It is not clear >> yet whether we'd just hook up on one of the existing >> Oracle interfaces or invent our own. > > Tell me more :-) Nothing much to tell yet - we're currently busy with other products, but the above idea is in the queue. -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Apr 21 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 ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Matthew T. Kromer wrote: And rumour has it I'm going to get some serious time to work on this soon! Matt, you up for fixing any C-level bugs that crawl out of the woodwork? Bugfixing, sure... :) How about a re-write so it's all squeeky clean? ;-) Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
M.-A. Lemburg wrote: Would a native Oracle interface help ? Yeah, and that's what DCOracle2 is, right? Nope. Huh? I think you need to provide a little more information there... If you're telling me you have a real live decent quality native oracle interface, then I'm all ears :-) We're considering working on one of these. It is not clear yet whether we'd just hook up on one of the existing Oracle interfaces or invent our own. Tell me more :-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
On Apr 19, 2005, at 4:24 AM, Chris Withers wrote: Matthew T. Kromer wrote: Chris Withers's branch of DCOracle2 has some changes that help the connection pooling problem. And rumour has it I'm going to get some serious time to work on this soon! Matt, you up for fixing any C-level bugs that crawl out of the woodwork? Bugfixing, sure... :) You can also consider using e-Genix's mxODBC adapter. This is a no-go if your Oracle people go "huh? ODBC? that's deprecated rubbish and you ain't using it" ;-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Chris Withers wrote: > M.-A. Lemburg wrote: > >> 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 > > > Interesting, but people here, even M$ people, haven't been using ODBC > for years... Well, can't have 'em all ;-) >>> Sadly, not in the slightest. For me, only normal oracle listeners will >>> ever be available :-( >> >> >> Would a native Oracle interface help ? > > Yeah, and that's what DCOracle2 is, right? Nope. > If you're telling me you have a real live decent quality native oracle > interface, then I'm all ears :-) We're considering working on one of these. It is not clear yet whether we'd just hook up on one of the existing Oracle interfaces or invent our own. -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Apr 20 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 ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
M.-A. Lemburg wrote: 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 Interesting, but people here, even M$ people, haven't been using ODBC for years... Sadly, not in the slightest. For me, only normal oracle listeners will ever be available :-( Would a native Oracle interface help ? Yeah, and that's what DCOracle2 is, right? If you're telling me you have a real live decent quality native oracle interface, then I'm all ears :-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
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 ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
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 ;-) ) 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 :-( cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Chris Withers wrote: > Matthew T. Kromer wrote: > >> Chris Withers's branch of DCOracle2 has some changes that help the >> connection pooling problem. > > > And rumour has it I'm going to get some serious time to work on this > soon! Matt, you up for fixing any C-level bugs that crawl out of the > woodwork? > >> You can also consider using eGenix's mxODBC adapter. > > > 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... Some people just love sitting hours in front of a their box to get things running - other's prefer to get the job done in 30 minutes and spend the rest of day doing something more interesting ;-) BTW, would calling it mxOracle Zope DA help ? (just testing waters here ;-) -- 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 ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Matthew T. Kromer wrote: Chris Withers's branch of DCOracle2 has some changes that help the connection pooling problem. And rumour has it I'm going to get some serious time to work on this soon! Matt, you up for fixing any C-level bugs that crawl out of the woodwork? You can also consider using e-Genix's mxODBC adapter. This is a no-go if your Oracle people go "huh? ODBC? that's deprecated rubbish and you ain't using it" ;-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Hi Cynthia, Cynthia Kiser wrote: When you do our own connection management, are you able to avoid DCOracle2 leaking connections? In our Zope 2.6.1/DCOracle2-1.3b server, we accumulate sessions where Oracle is waiting for a response from Zope, but Zope apparently thinks it closed that connection and opened a new one. If you google for my name, Oracle and Zope you'll find lots of information on the problem ;-) It's basically ZOracleDA's funny idea of connection pooling that causes the problem. Unless your ZSQL methods are hammered heavilly, you'll see plenty of unused oracle sessions. These aren't being leaked as you suggest, just not used very often. This results in "Oracle Not Connected" errors if your DBA sets a timeout on unused Oracle sessions... Manually closing and reopening the connection does not clean up the forgotten sessions, so I periodically (~monthly) restart the Zope server to clean up. Control Panel -> Database -> Main -> Flush Cache will have the same effect... me with the impression that its connection closing function did not work. It doesn't ;-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Matthew T. Kromer wrote: Chris Withers's branch of DCOracle2 has some changes that help the connection pooling problem. The issue basically is that the Zope adapter for DCOracle2 is fairly old and crusty. I think Jim's correct when he suggests doing your own pool management from a module. All that the DA is supposed to give you is a pool of connection objects and Zope transaction manager awareness. There's a little more to it than that, but the Zope DA is so old -- it derives from a product that predates Zope 2. It would probably be solved best by *jettisoning* Zope.Shared.RDBMS code, but... I don't actively maintain the code base any more (I haven't for about 18 months). It isn't totally abandoned, but I don't work with Oracle at work any more, and so I don't have much of an itch to scratch to fix problems. My home installs of Oracle have all gotten clobbered by entropy (read: re-installs of Linux to counter failed hardware). You can also consider using eGenix's mxODBC adapter. If you're on Windows, that's definitely worth a try. On Unix you'll need an ODBC driver for Oracle, e.g. the EasySoft one, since Oracle doesn't ship a driver with the database (even though they do on Windows and it would probably be easy for them to port it to Unix as well). On Apr 8, 2005, at 6:58 PM, Cynthia Kiser wrote: Quoting Jim Abramson <[EMAIL PROTECTED]>: In our experience we ended up needing to do increasingly complex things with plsql, and ultimately, we had no choice to move all our db access out into ExternalMethods or Products and use DCOracle2 directly. This does require constructing your own connection pool/management, but once you've built that you can leverage DCOracle2 directly in python and this provides much more flexibility. When you do our own connection management, are you able to avoid DCOracle2 leaking connections? In our Zope 2.6.1/DCOracle2-1.3b server, we accumulate sessions where Oracle is waiting for a response from Zope, but Zope apparently thinks it closed that connection and opened a new one. Manually closing and reopening the connection does not clean up the forgotten sessions, so I periodically (~monthly) restart the Zope server to clean up. Killing the Zope processes seems to finally signal Oracle (on a remote machine) that the client is no longer interested in those old open sessions. The smidge of testing I did with DCOracle2 from the command line left me with the impression that its connection closing function did not work. I could close a connection - and then still use it to talk to my database. I wasn't really sure enough of those tests to report this as a bug, but it is vaguely troubling. -- Cynthia Kiser ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Apr 13 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 ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Chris Withers's branch of DCOracle2 has some changes that help the connection pooling problem. The issue basically is that the Zope adapter for DCOracle2 is fairly old and crusty. I think Jim's correct when he suggests doing your own pool management from a module. All that the DA is supposed to give you is a pool of connection objects and Zope transaction manager awareness. There's a little more to it than that, but the Zope DA is so old -- it derives from a product that predates Zope 2. It would probably be solved best by *jettisoning* Zope.Shared.RDBMS code, but... I don't actively maintain the code base any more (I haven't for about 18 months). It isn't totally abandoned, but I don't work with Oracle at work any more, and so I don't have much of an itch to scratch to fix problems. My home installs of Oracle have all gotten clobbered by entropy (read: re-installs of Linux to counter failed hardware). You can also consider using e-Genix's mxODBC adapter. On Apr 8, 2005, at 6:58 PM, Cynthia Kiser wrote: Quoting Jim Abramson <[EMAIL PROTECTED]>: In our experience we ended up needing to do increasingly complex things with plsql, and ultimately, we had no choice to move all our db access out into ExternalMethods or Products and use DCOracle2 directly. This does require constructing your own connection pool/management, but once you've built that you can leverage DCOracle2 directly in python and this provides much more flexibility. When you do our own connection management, are you able to avoid DCOracle2 leaking connections? In our Zope 2.6.1/DCOracle2-1.3b server, we accumulate sessions where Oracle is waiting for a response from Zope, but Zope apparently thinks it closed that connection and opened a new one. Manually closing and reopening the connection does not clean up the forgotten sessions, so I periodically (~monthly) restart the Zope server to clean up. Killing the Zope processes seems to finally signal Oracle (on a remote machine) that the client is no longer interested in those old open sessions. The smidge of testing I did with DCOracle2 from the command line left me with the impression that its connection closing function did not work. I could close a connection - and then still use it to talk to my database. I wasn't really sure enough of those tests to report this as a bug, but it is vaguely troubling. -- Cynthia Kiser ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
> for functions, you can do something like > select my_function_result() from dual > (assuming your function returns a scalar of some kind.)/ / Thank you. I think that 'dual' will solve few my problems. I'm not an oracle developer so I didn't know about this method. Really strange for me - it was so easy in Sybase or Postgres to get values from functions (not only scalars). /> for procedures, you can do the DCOracle2 Stored Procedure (might be > called ZOracleDA Stored Procedure in your install...) / I don't want to use these procedures beacause they are specific to DCOracle2 driver only, so when I'll want to move to SQLRelay for example it will be not possible to transfer it easily. We have some problems with our DBConnections and DCOracle2 is suspected and more: there were problems with installing DCOracle2 on Mainframe machine, so I want to test SQLRelay. /> ultimately, we had no choice to move all our db access out into > ExternalMethods or Products and use DCOracle2 directly. This does > require constructing your own connection pool/management, but once > you've built that you can leverage DCOracle2 directly in python and this > provides much more flexibility. / Yes... maybe writing own product will be a good idea. /> hth > Jim / Thanks! -- Maciej ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
Quoting Jim Abramson <[EMAIL PROTECTED]>: > In our experience we ended up needing to do increasingly complex > things with plsql, and ultimately, we had no choice to move all our > db access out into ExternalMethods or Products and use DCOracle2 > directly. This does require constructing your own connection > pool/management, but once you've built that you can leverage > DCOracle2 directly in python and this provides much more > flexibility. When you do our own connection management, are you able to avoid DCOracle2 leaking connections? In our Zope 2.6.1/DCOracle2-1.3b server, we accumulate sessions where Oracle is waiting for a response from Zope, but Zope apparently thinks it closed that connection and opened a new one. Manually closing and reopening the connection does not clean up the forgotten sessions, so I periodically (~monthly) restart the Zope server to clean up. Killing the Zope processes seems to finally signal Oracle (on a remote machine) that the client is no longer interested in those old open sessions. The smidge of testing I did with DCOracle2 from the command line left me with the impression that its connection closing function did not work. I could close a connection - and then still use it to talk to my database. I wasn't really sure enough of those tests to report this as a bug, but it is vaguely troubling. -- Cynthia Kiser ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
RE: [Zope-DB] Returning values from Oracle function/procedure withZSQLMethod
for functions, you can do something like select my_function_result() from dual (assuming your function returns a scalar of some kind.) for procedures, you can do the DCOracle2 Stored Procedure (might be called ZOracleDA Stored Procedure in your install...) OTOH I've found the procedure objects a bit flaky. In our experience we ended up needing to do increasingly complex things with plsql, and ultimately, we had no choice to move all our db access out into ExternalMethods or Products and use DCOracle2 directly. This does require constructing your own connection pool/management, but once you've built that you can leverage DCOracle2 directly in python and this provides much more flexibility. hth Jim > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Maciej Wisniowski > Sent: Friday, April 08, 2005 2:28 PM > To: Zope-DB@zope.org > Subject: [Zope-DB] Returning values from Oracle > function/procedure withZSQLMethod > > Hi > > I'm using DCOracle2 to connect to Oracle databases, but I > think that moving to SQLRelay may be a good idea. I haven't > tried it yet but I wonder how to get any values returned from > oracle function and/or procedures using only ZSQLMethods? > > I've made few tries with DCOracle to call functions from > ZSQLMethod and to return a value to calling python script, > but I wasn't successful with this. It was pretty simple in > Sybase or PostgreSQL but how to do this with oracle? > > Suppose that I have database function: get_next_code() in > database that returns integer value. How my ZSQLMethod body > should look like to return value to Python script that called > this ZSQLMethod? I think it'll be same in DCOracle2 and in > ZSQLRelayDA. Am I wrong? > > Another option is to get in/out parameters from procedures... > is this possible with ZSQLRelayDA? > > -- > Maciej > ___ > Zope-DB mailing list > Zope-DB@zope.org > http://mail.zope.org/mailman/listinfo/zope-db > ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db