orastuff.h File Reference

Data Structures
struct	Bind_Variable_Specification
struct	Table_Column_Attributes
struct	Select_List_Item_Specification
struct	SQL_Statement_Specification
struct	Cursor_Components
Defines
#define	SQLCA_INIT
#define	NUM_CURSORS   21
#define	ORACLE_EXCEPTION   2
#define	INTERFACE_EXCEPTION   1
#define	SUCCESS   0
#define	INTERFACE_ERROR   -1
#define	ORACLE_ERROR   -2
#define	IsExceptionStatus(Status)   (Status > SUCCESS)
#define	IsSuccessStatus(Status)   (Status == SUCCESS)
#define	IsFailureStatus(Status)   (Status < SUCCESS)
#define	SQLDA_NumEntriesAlloced(SQLDA)   ((SQLDA)->N)
#define	SQLDA_ItemValueArrayBase(SQLDA, Index)   ((SQLDA)->V[Index])
#define	SQLDA_ItemValueArrayWidth(SQLDA, Index)   ((SQLDA)->L[Index])
#define	SQLDA_ItemValueArrayType(SQLDA, Index)   ((SQLDA)->T[Index])
#define	SQLDA_IndValueArrayBase(SQLDA, Index)   ((SQLDA)->I[Index])
#define	SQLDA_NumEntriesFound(SQLDA)   ((SQLDA)->F)
#define	SQLDA_ItemNameBuffer(SQLDA, Index)   ((SQLDA)->S[Index])
#define	SQLDA_ItemNameBufLen(SQLDA, Index)   ((SQLDA)->M[Index])
#define	SQLDA_ItemNameLength(SQLDA, Index)   ((SQLDA)->C[Index])
#define	SQLDA_IndNameBuffer(SQLDA, Index)   ((SQLDA)->X[Index])
#define	SQLDA_IndNameBufLen(SQLDA, Index)   ((SQLDA)->Y[Index])
#define	SQLDA_IndNameLength(SQLDA, Index)   ((SQLDA)->Z[Index])
#define	MAX_NUM_IOVALUES   100
#define	BINDVAR_NAME_BUFFER_SIZE   8
#define	SLI_NAME_BUFFER_SIZE   30
#define	ROWID_TO_STRING_BUFSIZE   20
#define	DATE_TO_STRING_BUFSIZE   10
#define	LONG_TO_STRING_BUFSIZE   100
#define	DEFAULT_INPUTARRAY_LENGTH   200
#define	DEFAULT_INPUTARRAY_WIDTH   30
#define	DEFAULT_OUTPUTARRAY_LENGTH   200
#define	INVALID_CURSOR_HANDLE   -1
Typedefs
typedef unsigned int	uint
typedef Bind_Variable_Specification	BindVarSpec
typedef Table_Column_Attributes	ColumnSpec
typedef Select_List_Item_Specification	SLI_Spec
typedef unsigned int	TemplateNumber
typedef enum SQL_Stmt_Type_Classes	SqlStmtType
typedef SQL_Statement_Specification	SqlStmtSpec
typedef int	CursorHandle
typedef enum Cursor_Status	CursorStatus
typedef Cursor_Components	Cursor
Enumerations
enum	OracleDataTypes {   VARCHAR2_ODT = 1, NUMBER_ODT = 2, LONG_ODT = 8, ROWID_ODT = 11,   DATE_ODT = 12, RAW_ODT = 23, LONGRAW_ODT = 24, CHAR_ODT = 96,   INTEGER_ODT = 3, FLOAT_ODT = 4, STRING_ODT = 5, VARNUM_ODT = 6,   VARCHAR_ODT = 9, VARRAW_ODT = 15, UNSIGNED_ODT = 68, LONGVARCHAR_ODT = 94,   LONGVARRAW_ODT = 95, CHARZ_ODT = 97 }
enum	SQL_Stmt_Type_Classes { SELECT_SQL_STMT = 0, INSERT_SQL_STMT = 1, CURSOR_DAMAGING_SQL_STMT = 2, OTHER_SQL_STMT = 3 }
enum	Cursor_Status { UNUSED_CURSOR_STATUS, ACTIVE_CURSOR_STATUS, INACTIVE_CURSOR_STATUS, INVALID_CURSOR_STATUS }
Functions
SQLDA *	sqlald (int, unsigned int, unsigned int)
void	sqlclu (SQLDA *)
void	sqlnul (short *, short *, int *)
void	sqlprc (long *, int *, int *)
Variables
EXEC SQL INCLUDE	sqlca
EXEC SQL INCLUDE	sqlda

---

Define Documentation

#define BINDVAR_NAME_BUFFER_SIZE   8

#define DATE_TO_STRING_BUFSIZE   10

#define DEFAULT_INPUTARRAY_LENGTH   200

#define DEFAULT_INPUTARRAY_WIDTH   30

#define DEFAULT_OUTPUTARRAY_LENGTH   200

#define INTERFACE_ERROR   -1

#define INTERFACE_EXCEPTION   1

#define INVALID_CURSOR_HANDLE   -1

#define IsExceptionStatus (  Status   )     (Status > SUCCESS)

#define IsFailureStatus (  Status   )     (Status < SUCCESS)

#define IsSuccessStatus (  Status   )     (Status == SUCCESS)

#define LONG_TO_STRING_BUFSIZE   100

#define MAX_NUM_IOVALUES   100

#define NUM_CURSORS   21

#define ORACLE_ERROR   -2

#define ORACLE_EXCEPTION   2

#define ROWID_TO_STRING_BUFSIZE   20

#define SLI_NAME_BUFFER_SIZE   30

#define SQLCA_INIT

#define SQLDA_IndNameBuffer (  SQLDA, Index   )     ((SQLDA)->X[Index])

#define SQLDA_IndNameBufLen (  SQLDA, Index   )     ((SQLDA)->Y[Index])

#define SQLDA_IndNameLength (  SQLDA, Index   )     ((SQLDA)->Z[Index])

#define SQLDA_IndValueArrayBase (  SQLDA, Index   )     ((SQLDA)->I[Index])

#define SQLDA_ItemNameBuffer (  SQLDA, Index   )     ((SQLDA)->S[Index])

#define SQLDA_ItemNameBufLen (  SQLDA, Index   )     ((SQLDA)->M[Index])

#define SQLDA_ItemNameLength (  SQLDA, Index   )     ((SQLDA)->C[Index])

#define SQLDA_ItemValueArrayBase (  SQLDA, Index   )     ((SQLDA)->V[Index])

#define SQLDA_ItemValueArrayType (  SQLDA, Index   )     ((SQLDA)->T[Index])

#define SQLDA_ItemValueArrayWidth (  SQLDA, Index   )     ((SQLDA)->L[Index])

#define SQLDA_NumEntriesAlloced (  SQLDA   )     ((SQLDA)->N)

#define SQLDA_NumEntriesFound (  SQLDA   )     ((SQLDA)->F)

#define SUCCESS   0

---

Typedef Documentation

typedef struct Bind_Variable_Specification BindVarSpec

typedef struct Table_Column_Attributes ColumnSpec

typedef struct Cursor_Components Cursor

typedef int CursorHandle

typedef enum Cursor_Status CursorStatus

typedef struct Select_List_Item_Specification SLI_Spec

typedef struct SQL_Statement_Specification SqlStmtSpec

typedef enum SQL_Stmt_Type_Classes SqlStmtType

typedef unsigned int TemplateNumber

typedef unsigned int uint

---

Enumeration Type Documentation

enum Cursor_Status

Enumerator: UNUSED_CURSOR_STATUS  ACTIVE_CURSOR_STATUS  INACTIVE_CURSOR_STATUS  INVALID_CURSOR_STATUS

enum OracleDataTypes

Enumerator: VARCHAR2_ODT  NUMBER_ODT  LONG_ODT  ROWID_ODT  DATE_ODT  RAW_ODT  LONGRAW_ODT  CHAR_ODT  INTEGER_ODT  FLOAT_ODT  STRING_ODT  VARNUM_ODT  VARCHAR_ODT  VARRAW_ODT  UNSIGNED_ODT  LONGVARCHAR_ODT  LONGVARRAW_ODT  CHARZ_ODT

enum SQL_Stmt_Type_Classes

Enumerator: SELECT_SQL_STMT  INSERT_SQL_STMT  CURSOR_DAMAGING_SQL_STMT  OTHER_SQL_STMT

---

Function Documentation

SQLDA* sqlald (  int  , unsigned  int, unsigned  int )

void sqlclu (  SQLDA *   )

void sqlnul (  short *  , short *  , int *  )

void sqlprc (  long *  , int *  , int *  )

---

Variable Documentation

EXEC SQL INCLUDE sqlca

EXEC SQL INCLUDE sqlda

---