sqlcode 100 does not come with exception
862792Jan 11 2012 — edited Jan 11 2012I have following query
SELECT a.col1 into v_acc_account FROM account_t a
WHERE a.col1=<input paramter> FOR UPDATE OF a.col1 NOWAIT;
The statement returns sqlcode of 100 and does not throw exception
From oracle documentation I understand that the errorcode is accompanied by an exception. What may be the reason behind this behavior.
The return code 100 explains 'DATA NOT FOUND", we have data for the select query.
Data not found means, the select is failing or the locks not available.
any help much appreciated
Regards,
Nandish