Stmt.exeC Stmt.checkClosed Stmt is closed

Question

Stmt.exeC Stmt.checkClosed Stmt is closed

vamkaxifa opened this issue 7 years ago · 3 comments

Hey guys, I got this err Stmt.exeC Stmt.checkClosed Stmt is closed when I called stored procedure form Oracle . I guess this may associate with commit in stored procedure, but after I removed commit , I still got this error . I can't figure out where does the bug lie. Does anybody know?

Answer 1 · 2017-09-11T08:34:48.000Z

rowsAffected, err := stmtProcCall.Exe(interfaceInArr...)
	if err != nil {
		log.Error("stmtProcCall.Exe occurs error:", err.Error())
		return
	}

This pice of code got err: stmtProcCall.Exe occurs error:Stmt.exeC Stmt.checkClosed Stmt is closed.

Answer 2 · 2017-09-11T10:16:17.000Z

Are you sure that stmt is not closed, and prepared properly?

…

On 2017. szept. 11., H 10:34 Nancy ***@***.***> wrote: rowsAffected, err := stmtProcCall.Exe(interfaceInArr...) if err != nil { log.Error("stmtProcCall.Exe occurs error:", err.Error()) return } This pice of code got err: stmtProcCall.Exe occurs error:Stmt.exeC Stmt.checkClosed Stmt is closed. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#218 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAPoSj-XY4_1jF2gFHtEznI19VLNhrz8ks5shPCogaJpZM4PSzq8> .

Answer 3 · 2017-09-13T06:56:38.000Z

Thank you very much! It turns out that I miss defer in front of stmtProcCall.Close(), which result in that err ... my mistake ...