SQL CODE -501

kumar_ngl · New User Joined: 05 Aug 2005 Posts: 50 Location: chennai

Hi all,

Plz anyone explain me what is sql code -501????I was asked this question in an interview.....

thanks,
kumar.p.v

harinatha · New User Joined: 24 Jul 2005 Posts: 28

Hi Kumar,

U can check this error code in any book..
anyway this is explained below.
-501 THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN

Iam trying to fetch or close the cursor which is not open.

Thanks & Regards,
Hari.

ravikumarreddy · New User Joined: 29 Jul 2005 Posts: 23

hi,

i would like to add some more information to the above answer.
All the sqlcodes like -501,-502,-503,-504 are related to cursors only.
so make note of these..

regards,
ravi

kumar_ngl · New User Joined: 05 Aug 2005 Posts: 50 Location: chennai

thanx hari

kumar