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
