[Zope-DB] mxODBC w/Oracle ODBC Drivers and zSQL Stored Proc Question

Edward Muller edwardam at interlix.com
Fri Sep 2 13:53:43 EDT 2005

Would it be possible to execute a query like below using zSQL Methods.

   tname STRING;
CALL sp_buildSet(22,330,tname);
   select_string := 'SELECT * FROM :1';
   EXECUTE IMMEDIATE select_string USING tname;

Assuming that the above is a valid Oracle query.

Or will we need to execute the stored procedure (sp_buildSet) from a python 

Never had to call stored procedures before so I don't know if I can from a 
zSQL Method.

Edward Muller - Interlix
edwardam at interlix.com
PGP Key: http://interlix.com/Members/edwardam/pgpkeys
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope-db/attachments/20050902/46197e76/attachment.bin

More information about the Zope-DB mailing list