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

[Massimo Di Pierro]

I do not think this is a DAL issue. This looks database issue or a driver 
issue. Web2py does not do another else but pass your SQL to the driver and 
fetch responses.

Is this SQLITE? In any case, I suggest you try the native driver APIs.

On Monday, 27 August 2012 09:37:45 UTC-5, 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)
>
>
>

--