cdemodr2.h

oci程序

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <oci.h>


#define MAXBINDS       25
#define MAXROWS         5           /* max no of rows returned per iter */
#define MAXCOLS         4
#define MAXITER        10           /* max no of iters in execute */
#define MAXBUFLEN      40

int main(/*_ int argc, char *argv[] _*/);
sword init_handles(/*_ OCIEnv **envhp, OCISvcCtx **svchp,
                               OCIError **errhp, OCIServer **svrhp,
                               OCISession **authp, ub4 mode _*/);

sword attach_server(/*_ ub4 mode, OCIServer *srvhp,
                        OCIError *errhp, OCISvcCtx *svchp _*/);
sword log_on(/*_ OCISession *authp, OCIError *errhp, OCISvcCtx *svchp,
                        text *uid, text *pwd, ub4 credt, ub4 mode _*/);
sword alloc_bind_handle(/*_ OCIStmt *stmthp, OCIBind *bndhp[],
                                   int nbinds _*/);
void print_raw(/*_ ub1 *raw, ub4 rawlen _*/);

void free_handles(/*_ OCIEnv *envhp, OCISvcCtx *svchp, OCIServer *srvhp,
                      OCIError *errhp, OCISession *authp, OCIStmt *stmthp _*/);
void report_error(/*_ OCIError *errhp _*/);
void logout_detach_server(/*_ OCISvcCtx *svchp, OCIServer *srvhp,
                              OCIError *errhp, OCISession *authp,
                              text *userid _*/);
sword finish_demo(/*_ boolean loggedon, OCIEnv *envhp, OCISvcCtx *svchp,
                      OCIServer *srvhp, OCIError *errhp, OCISession *authp,
                      OCIStmt *stmthp, text *userid _*/);
sword demo_insert(/*_ OCISvcCtx *svchp, OCIStmt *stmthp,
                              OCIBind *bndhp[], OCIError *errhp _*/);
sword demo_update(/*_ OCISvcCtx *svchp, OCIStmt *stmthp,
                              OCIBind *bndhp[], OCIError *errhp _*/);
sword demo_delete(/*_ OCISvcCtx *svchp, OCIStmt *stmthp,
                              OCIBind *bndhp[], OCIError *errhp _*/);
sword bind_name(/*_ OCIStmt *stmthp, OCIBind *bndhp[], OCIError *errhp _*/);
sword bind_in_name(/*_ OCIStmt *stmthp, OCIBind *bndhp[], OCIError *errhp _*/);
sword bind_low_high(/*_ OCIStmt *stmthp, OCIBind *bndhp[],
                        OCIError *errhp _*/);
sword bind_input(/*_ OCIStmt *stmthp, OCIBind *bndhp[], OCIError *errhp _*/);
sword bind_output(/*_ OCIStmt *stmthp, OCIBind *bndhp[], OCIError *errhp _*/);
sword bind_array(/*_ OCIBind *bndhp[], OCIError *errhp _*/);
sword bind_dynamic(/*_ OCIBind *bndhp[], OCIError *errhp _*/);
sb4 cbf_no_data(/*_ dvoid *ctxp, OCIBind *bindp, ub4 iter, ub4 index,
                 dvoid **bufpp, ub4 *alenpp, ub1 *piecep, dvoid **indpp _*/);
sb4 cbf_get_data(/*_ dvoid *ctxp, OCIBind *bindp, ub4 iter, ub4 index,
                             dvoid **bufpp, ub4 **alenpp, ub1 *piecep,
                             dvoid **indpp, ub2 **rcodepp _*/);
sword alloc_buffer(/*_ ub4 pos, ub4 iter, ub4 rows _*/);
sword read_piece(/*_ OCISvcCtx *svchp, OCILobLocator *lob, ub2 lobtype _*/);
sword write_piece(/*_ OCISvcCtx *svchp, OCILobLocator *lob, ub2 lobtype _*/);
sword check_lob(/*_ int iter, OCISvcCtx *svchp _*/);
sword locator_alloc(/*_ OCILobLocator *lob[], ub4 nlobs _*/);
sword locator_free(/*_ OCILobLocator *lob[], ub4 nlobs _*/);
sword select_locator(/*_ OCISvcCtx *svchp, OCIStmt *stmthp,
                                 OCIBind *bndhp[], OCIError *errhp _*/);