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)


-- 



Reply via email to