/*
 * $Header: cdemodr3.h 03-jun-97.18:15:59 azhao Exp $
 */

/* Copyright (c) Oracle Corporation 1997. All Rights Reserved. */ 
 
/* NOTE:  See 'header_template.doc' in the 'doc' dve under the 'forms' 
      directory for the header file template that includes instructions. 
*/
 
/* 
   NAME 
     <<<LOWERCASE_FILENAME>>>.h - <one-line expansion of the name> 

   DESCRIPTION 
     <short description of component this file declares/defines> 

   RELATED DOCUMENTS 
 
   INSPECTION STATUS 
     Inspection date: 
     Inspection status: 
     Estimated increasing cost defects per page: 
     Rule sets: 
 
   ACCEPTANCE REVIEW STATUS 
     Review date: 
     Review status: 
     Reviewers: 
 
   PUBLIC FUNCTION(S) 
     <list of external functions declared/defined - with one-line descriptions>

   PRIVATE FUNCTION(S)
     <list of static functions defined in .c file - with one-line descriptions>

   EXAMPLES

   NOTES
     <other useful comments, qualifications, etc.>

   MODIFIED   (MM/DD/YY)
   azhao       06/03/97 - Creation

*/

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

#define MAXBINDS       5
#define MAXITER        5
#define MAXCOLS        2
#define MAXZIPLEN      10

struct address
{
  OCIString *state;
  OCIString *zip;
};

typedef struct address address;
 
struct null_address
{
  sb2    null_address;
  sb2    null_state;
  sb2    null_zip;
};

typedef struct null_address null_address;


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 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 bind_input(/*_ OCIStmt *stmthp, OCIBind *bndhp[], OCIError *errhp _*/);
sword bind_output(/*_ OCIStmt *stmthp, 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 _*/);