[web2py] Re: DAL calls fail after first stored procedure call

[villas]

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)
>
>
>

--