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]
