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
[EMAIL PROTECTED]
417-862-0573
PGP Key: http://interlix.com/Members/edwardam/pgpkeys

Attachment: pgpXOo6eIUNjU.pgp
Description: PGP signature

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Reply via email to