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

[Yarin]

Pretty desperate on this one- brought everything to a screeching halt. We 
need to be able to call more than one stored procedure per request. Anybody 
got any ideas?

On Monday, August 27, 2012 10:37:45 AM UTC-4, Yarin wrote:
>
> Once I call a stored procedure through the DAL, any subsequent 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)
>
>
>

--