Hi All,

I'm using ASE 12.5. When i use scrollable cursors, i face problems. Here is my stored procedure.
Code:
create proc spcursortest
as
begin
declare cursor1 scroll cursor
for select no from numbervaltab
open cursor1
fetch first cursor1
close cursor1
deallocate cursor cursor1
end
I get errors as follows.
Code:
QLException :: (Incorrect syntax near 'scroll'., sqlcode=102, sqlstate=42000)

[13:05:40] [0] Chained SQL Exception :: (Incorrect syntax near 'cursor1'., sqlcode=102, sqlstate=42000)
When i use non scrollable cursors, i don't face any probs.

Any help would highly be appreciated.
Thanks,
Sumesh