Villas- Thanks but no it doesn't- tried that.. On Monday, August 27, 2012 1:53:32 PM UTC-4, villas wrote: > > Just a thought - does db.commit() help? > Rgds, D > > On Monday, August 27, 2012 3:37:45 PM UTC+1, Yarin wrote: >> >> Once we call a stored procedure through the DAL, any subsequent DAL calls >> are returning None results. >> >> *Basic stored procedure:* >> BEGIN >> SELECT * FROM people; >> END >> >> *Works:* >> def test(): >> >> sql = "CALL GetPeople();" >> sproc_results = db_test.executesql(sql) >> >> return str(sproc_results) >> >> *Works:* >> def test(): >> >> sql = "SELECT * FROM people;" >> reg_results = db_test.executesql(sql) >> >> return str(reg_results) >> >> *Returns None:* >> def test(): >> >> sql = "CALL GetPeople();" >> sproc_results = db_test.executesql(sql) >> >> sql = "SELECT * FROM people;" >> reg_results = db_test.executesql(sql) >> >> return str(reg_results) >> >> *Returns None:* >> def test(): >> >> sql = "CALL GetPeople();" >> sproc_results = db_test.executesql(sql) >> >> sql = "CALL GetPeople();" >> sproc_results = db_test.executesql(sql) >> >> return str(sproc_results) >> >> >>
--
