Re: FREE (cursor)

>Could someone explain the advantages/disadvantages of issuing a CLOSE >cursor statement and then issuing a FREE cursor statement?. IF the cursor >has been prepared, will the FREE statement require it to be prepared >again? > > Basically, the Free statement will free up the "entire" query that is in shared memory. If the same statement is "re-prepared" there is an implicit free. The biggest advantage --- If the cursor is freed, then all memory associated with the prepare/declare is freed. If the cursor is only closed, then the basic parts of the statment hang arround. Madison Pruet