SQL-02122 Invalid OPEN or PREPARE for this database connection
Cause
An attempt was made to execute an OPEN or a PREPARE statement using a cursor that is currently open for another database connection and, therefore, cannot be used for this connection.
Action
Close the cursor to make it available for this connection or use a different cursor for this connection.
EXEC SQL at :db_name prepare COUNTHR_SEL from :H_sql;
如果上面这句话出错，之后换个数据库连接再执行上面这句话，就会报02122错误，是什么问题？该如何解决？prepare没有close一说吧？
第一次查询如果出现table or view not exists这种错
第二次查询就会报 SQL-02122的错
Cause
An attempt was made to execute an OPEN or a PREPARE statement using a cursor that is currently open for another database connection and, therefore, cannot be used for this connection.
Action
Close the cursor to make it available for this connection or use a different cursor for this connection.
EXEC SQL at :db_name prepare COUNTHR_SEL from :H_sql;
如果上面这句话出错，之后换个数据库连接再执行上面这句话，就会报02122错误，是什么问题？该如何解决？prepare没有close一说吧？
第一次查询如果出现table or view not exists这种错
第二次查询就会报 SQL-02122的错
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7319461/viewspace-765259/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/7319461/viewspace-765259/
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
