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
pgpXOo6eIUNjU.pgp
Description: PGP signature
_______________________________________________ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db