/*
 *========================================================================
 *
 *    : AZN_PLAZA_LANE APP
 *      : ora_sql.h
 *      : JBY 
 *      : 2018.07.13
 *      : 
 *        : Oracle SQL CODE/MSG/ROWCNT/EML/NUM/OK/DUP/NODATA/NULL/TAILNULL/DISCON/EXIST
 *
 *========================================================================
*/

#ifndef  _ORA_SQL__
#define  _ORA_SQL__

#include     <sqlca.h>
#include     <sqlda.h>
#include     <sqlcpr.h>
#include     <oraca.h>

#define NOTFOUND    1403                    /* Oracle error code            */
#define SQLCODE     sqlca.sqlcode             /* Oracle error code variable   */
#define SQLMSG      sqlca.sqlerrm.sqlerrmc    /* Oracle error message         */
#define SQLROWCNT   sqlca.sqlerrd[2]          /* Oracle row count             */
#define SQLEML      sqlca.sqlerrm.sqlerrml
#define SQLNUM      sqlca.sqlerrd[2]
#define SQLSTMT     sqlstm.stmt
#define SQLOK       (0)      /* query success           */
#define SQLDUP      (-1)      
#define SQLNODATA   (1403)
#define SQLNULL     (-1405)  /* include NULL data field */
#define SQLTAILNULL (-1480)  /* null-terminated string  */
#define SQLDISCON   (-1012)  /* DB Disconnect           */
#define NON_EXIST   (-942)

extern long    db_errno;

#endif 
