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

[Edward Muller]

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

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

Assuming that the above is a valid Oracle query.

Or will we need to execute the stored procedure (sp_buildSet) from a python 
script/product.

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
417-862-0573
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