OCI : Handling no data found exception (01403)

Interesting things happen in this world. Exception 01403 (NO DATA FOUND) converts to OCI_NO_DATA status.

OCI error code :

/*————————Error Return Values——————————–*/
#define OCI_SUCCESS 0 /* maps to SQL_SUCCESS of SAG CLI */
#define OCI_SUCCESS_WITH_INFO 1 /* maps to SQL_SUCCESS_WITH_INFO */
#define OCI_RESERVED_FOR_INT_USE 200 /* reserved */
#define OCI_NO_DATA 100 /* maps to SQL_NO_DATA */
#define OCI_ERROR -1 /* maps to SQL_ERROR */
#define OCI_INVALID_HANDLE -2 /* maps to SQL_INVALID_HANDLE */
#define OCI_NEED_DATA 99 /* maps to SQL_NEED_DATA */
#define OCI_STILL_EXECUTING -3123 /* OCI would block error */

So, if database raised exception NO_DATA_FOUND(01403)  we expected OCI_ERROR, but OCI handles exception 01403 as OCI_NO_DATA.