SQL CODE -501

kumar_ngl · Posted: Wed Aug 31, 2005 10:11 pm Post subject: SQL CODE -501

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: 31

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: 24

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 · Posted: Thu Sep 01, 2005 12:13 pm Post subject: Re: SQL CODE -501

thanx hari

kumar