examples.h

一个很好用的Linux/Unix下Oracle OCI开发接口封装库

/* $Id: examples.h,v 1.1 2005/01/13 02:56:43 cvsroot Exp $ */
#ifndef __EXAMPLES_H
#define __EXAMPLES_H
#include "sqlora.h"

#undef __P
#if (defined(PROTOTYPES) || defined(__STDC__) || defined(__cplusplus) )
# define __P(protos) protos
#else
# define __P(protos) ()
#endif

/**
 * Print last sql error, rollback, logout and exit with FAILURE
 *
 * See error_exit.c
 */
void do_error_exit __P((sqlo_db_handle_t dbh, CONST char *file, int line,  
                        CONST char * msg));

#define error_exit(_dbh, _msg) do_error_exit(_dbh, __FILE__, __LINE__, _msg)

/**
 * ex1.c
 */
int table_exists __P((sqlo_db_handle_t dbh, char * table_name));

/**
 * ex2.c
 */
int col_count __P((sqlo_db_handle_t dbh, char * table_name));

/**
 * ex3.c
 */
int update_manager __P((sqlo_db_handle_t dbh));

/**
 * ex4.c
 */
sqlo_stmt_handle_t open_cursor __P((sqlo_db_handle_t dbh));

/**
 * ex5.c
 */
sqlo_stmt_handle_t open_cursor2 __P((sqlo_db_handle_t dbh, double min_income));

/**
 * ex6.c
 */
sqlo_stmt_handle_t reopen_cursor __P((sqlo_db_handle_t dbh, double min_income));

/**
 * ex7.c
 */
int do_select __P((sqlo_db_handle_t dbh, double min_income));

/**
 * ex8.c
 */
int update_emp __P((sqlo_db_handle_t dbh, double factor, const char * job));

/**
 * ex9.c
 */
int call_plsql __P((sqlo_db_handle_t dbh));

/**
 * ex10.c
 */
sqlo_stmt_handle_t prepare_cursor __P((sqlo_db_handle_t dbh, double* min_salary));

/**
 * ex11.c
 */
sqlo_stmt_handle_t do_select2 __P((sqlo_db_handle_t dbh, double min_salary));

/**
 * ex12.c
 */
int do_array_select __P((sqlo_db_handle_t dbh, double min_salary));

/**
 * ex13.c
 */
enum {
  MAX_BLOB_BUFFER_DATA = 65535
};

int insert_into_blob_table __P(( sqlo_db_handle_t dbh, int key ));
void create_blob_table __P((sqlo_db_handle_t dbh));
void drop_blob_table __P((sqlo_db_handle_t dbh));
void fillbuf __P((char * data, int len));

/**
 * ex14.c
 */
int insert_file_into_blob_table __P((sqlo_db_handle_t dbh, int key, const char * fname ));

/**
 * ex15.c
 */
int select_from_blob_table __P(( sqlo_db_handle_t dbh, int key ));

/**
 * ex16.c
 */
int select_file_from_blob_table __P(( sqlo_db_handle_t dbh, int key, const char * fname ));

/**
 * ex17.c
 */
int select_refcursor __P((sqlo_db_handle_t dbh, double min_salary));

/**
 * ex18.c
 */
int select_refcursor2 __P((sqlo_db_handle_t dbh, double min_salary));

/**
 * ex19.c
 */
int select_ntable __P((sqlo_db_handle_t dbh));


#endif 
/* $Id: examples.h,v 1.1 2005/01/13 02:56:43 cvsroot Exp $ */