Cursors get closed when Commit is issued in SP

Database
Enthusiast

Cursors get closed when Commit is issued in SP

Hi ,

I have a user who has coded a SP and trying to run in ANSI (sicen this SP will run from informatica and all connections are in ANSI). She has some DDL statements in the SP and then she is using the tables/views later in the SP. she also has some cursors that get parameters from dbc tables that create the tables/views definition etc. She is using these tables and views in the SP later on. The cncern here is, after she has created the table, she issues a commit stmnt to create the table. here whatever cursors that she has opned gets closed as when we issue a commit in SP, cursor gets closed. But, she still need some cursors open as she needs then later in the code.

Is there a work around for this ?

--Samir Singh