Is this a bug in python for Cursor-Returning stored procedures? (causes the python shell to crash/restart)
regarding this post: http://archives.neohapsis.com/archives/dev/sapdb/2003-q1/0553.html I have also tried creating a DBPROC with dummy input parameters, but to no avail. Anyone got a working python script which creates a stored procedure that returns a cursor? eoghan --- Eoghan Murray <[EMAIL PROTECTED]> wrote: > I have the following > > >>> import sql > >>> session = > sql.connect("DBA","DBA","PORTAL","localhost") > >>> session.sql("""CREATE DBPROC pythontest RETURNS > CURSOR > AS > $CURSOR = 'PY_CURSOR'; > DECLARE :$CURSOR CURSOR FOR > SELECT * FROM DBA.TESTTABLE;""") > > The final statement causes a restart in the python > shell with a memory reference error. > > The similar statement from the manual works fine: > > session.sql ("""CREATE DBPROC paramdemo ( > IN p1 FIXED (5), > INOUT p2 FIXED, > OUT p3 FLOAT) > AS BEGIN > SET p2 = 2; > SET p3 = 3.0; > END;""") > > > Is it a bug caused by the creation of a cursor? > > I'm running python 2.4 and have tried it on python > 2.2 > to similar effect. > > Thx > Eoghan ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
