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....
endexec.

exec sql.
  close dbcursor
endexec. 

exec sql.
  deallocate dbcursor
endexec. 

I get a dump when i use deallocate dbcursor.

Can anyone let me know how can I use deallocate.

Regards,

Abdullah.

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