Sorry about the silence. We're working on a fix.
Ken
On Mon, Aug 27, 2012 at 1:50 PM, Jason M. Yi <93time@gmail.com> wrote:
Hi,We're trying to call a stored procedure on Cloud SQL in python2.7.Here's our simple code:# stored procedureCREATE PROCEDURE Test_Procedure (_nmbr INT)BEGININSERT INTO TEST(AA) VALUES(_nmbr);SELECT * FROM TEST;END;# code in pythonconn = rdbms.connect(instance = _INSTANCE_NAME, database = _DATABASE_NAME)cursor = conn.cursor()cursor.execute("call Test_Procedure(%s)", (50))results = cursor.fetchall()for row in results :self.response.out.write(str(row[0]))conn.close()When I executed the procedure on SQL Prompt, it worked very well, but when I tried to execute it by python code, I've gotten this error message.InternalError: fetchall() called before executeDo I have to do something else when I execute a stored procedure in python code??
No comments:
Post a Comment