Document my experience using Oracle pro*c/c++,pl/sql and vi editor.
Blog examples,tips and general information.
Tuesday, September 13, 2011
CURSOR Related SQLCODES
When you open a cursor , and if there are no rows to be selected, the cursor will not return NO DATA FOUND at this stage.
After fetching all the rows in a cursor :
sqlca.sqlcode returns 1403 NO DATA FOUND:It indicates the end of a cursor.
No comments:
Post a Comment