Page 1 of 1

Handling SQLCODE -811.

Posted: Mon Oct 03, 2016 3:38 pm
by RajuRastogi
Hi,

Is it possible that SQLCODE -811 occurs, even though cursor has been defined?

I know cursor is defined to handle -811 but can it still occur ina program even if cursor has been defined?

I don't know why would it happen,if it happens. Can somepme please asnwer me about this.

Re: Handling SQLCODE -811.

Posted: Tue Oct 04, 2016 9:34 am
by Chandan Yadav
It should not happen. Can you please post your SQL and cursor declaration where you are getting -811

Thanks,
Chandan

Re: Handling SQLCODE -811.

Posted: Tue Oct 04, 2016 11:15 am
by Anuj Dhawan
It's an interview question I doubt he'd be able to post the SQL.

Re: Handling SQLCODE -811.

Posted: Tue Oct 04, 2016 4:53 pm
by RajuRastogi
Yes. I have been asked in an interview that Is it possible that SQLCODE -811 occurs, even though cursor has been defined?