is it possible to get -811 error when you use cursors. why?
Answers were Sorted based on User's Feedback
When you are fetching cursor without declaration.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / purushothr
Yes it is possible only in cursor. if u trying to retrieve
more than one row at the same time by using cursor then -
811 error ll come.
| Is This Answer Correct ? | 6 Yes | 14 No |
What will the FREE command do to a plan?
Which component is used to execute the sql statements?
What else is there in the PLAN apart from the access path?
What is the purpose of the QUIESE Utility?
what is difference between Plan and Package
how will you retrieve first record in table
Explain an outer join?
What are PACKAGES ?
What is declare cursor?
how to identify the pseudo conversation by seeing the program
What is reorg in database?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?