Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Deallocate cursor - native SQL

Hi Experts,

I am writing a native SQL query. Can anyone know why the following native SQL statement is giving me a dump.

The database is MS SQL 2005

exec sql.
  open dbcursor for 
    select statement....

exec sql.
  close dbcursor

exec sql.
  deallocate dbcursor

I get a dump when i use deallocate dbcursor.

Can anyone let me know how can I use deallocate.



Former Member
Not what you were looking for? View more on this topic or Ask a question