/* Result Sets Interface */ #ifndef SQL_CRSR # define SQL_CRSR struct sql_cursor { unsigned int curocn; void *ptr1; void *ptr2; unsigned int magic; }; typedef struct sql_cursor sql_cursor; typedef struct sql_cursor SQL_CURSOR; #endif /* SQL_CRSR */ /* Thread Safety */ typedef void * sql_context; typedef void * SQL_CONTEXT; /* Object support */ struct sqltvn { unsigned char *tvnvsn; unsigned short tvnvsnl; unsigned char *tvnnm; unsigned short tvnnml; unsigned char *tvnsnm; unsigned short tvnsnml; }; typedef struct sqltvn sqltvn; struct sqladts { unsigned int adtvsn; unsigned short adtmode; unsigned short adtnum; sqltvn adttvn[1]; }; typedef struct sqladts sqladts; static struct sqladts sqladt = { 1,1,0, }; /* Binding to PL/SQL Records */ struct sqltdss { unsigned int tdsvsn; unsigned short tdsnum; unsigned char *tdsval[1]; }; typedef struct sqltdss sqltdss; static struct sqltdss sqltds = { 1, 0, }; /* File name & Package Name */ struct sqlcxp { unsigned short fillen; char filnam[14]; }; static struct sqlcxp sqlfpn = { 13, "msg2Oracle.pc" }; static unsigned int sqlctx = 622883; static struct sqlexd { unsigned int sqlvsn; unsigned int arrsiz; unsigned int iters; unsigned int offset; unsigned short selerr; unsigned short sqlety; unsigned int occurs; short *cud; unsigned char *sqlest; char *stmt; sqladts *sqladtp; sqltdss *sqltdsp; void **sqphsv; unsigned int *sqphsl; int *sqphss; void **sqpind; int *sqpins; unsigned int *sqparm; unsigned int **sqparc; unsigned short *sqpadto; unsigned short *sqptdso; unsigned int sqlcmax; unsigned int sqlcmin; unsigned int sqlcincr; unsigned int sqlctimeout; unsigned int sqlcnowait; int sqfoff; unsigned int sqcmod; unsigned int sqfmod; void *sqhstv[15]; unsigned int sqhstl[15]; int sqhsts[15]; void *sqindv[15]; int sqinds[15]; unsigned int sqharm[15]; unsigned int *sqharc[15]; unsigned short sqadto[15]; unsigned short sqtdso[15]; } sqlstm = {12,15}; /* SQLLIB Prototypes */ extern sqlcxt ( void **, unsigned int *, struct sqlexd *, struct sqlcxp * ); extern sqlcx2t( void **, unsigned int *, struct sqlexd *, struct sqlcxp * ); extern sqlbuft( void **, char * ); extern sqlgs2t( void **, char * ); extern sqlorat( void **, unsigned int *, void * ); /* Forms Interface */ static int IAPSUCC = 0; static int IAPFAIL = 1403; static int IAPFTL = 535; extern void sqliem( unsigned char *, signed int * ); typedef struct { unsigned short len; unsigned char arr[1]; } VARCHAR; typedef struct { unsigned short len; unsigned char arr[1]; } varchar; /* CUD (Compilation Unit Data) Array */ static short sqlcud0[] = {12,4130,1,0,0, 5,0,0,1,0,0,32,76,0,0,0,0,0,1,0, 20,0,0,0,0,0,27,130,0,0,4,4,0,1,0,1,97,0,0,1,10,0,0,1,10,0,0,1,10,0,0, 51,0,0,3,51,0,1,135,0,0,0,0,0,1,0, 66,0,0,4,0,0,30,146,0,0,0,0,0,1,0, 81,0,0,5,0,0,29,155,0,0,0,0,0,1,0, 96,0,0,6,676,0,3,250,0,0,15,15,0,1,0,1,5,0,0,1,5,0,0,1,5,0,0,1,5,0,0,1,5,0,0,1, 5,0,0,1,5,0,0,1,3,0,0,1,5,0,0,1,5,0,0,1,5,0,0,1,5,0,0,1,5,0,0,1,3,0,0,1,5,0,0, 171,0,0,7,0,0,29,298,0,0,0,0,0,1,0, }; /* errlog_interface.pc Author: Elie Grunhaus, SLAC, ext. 3499 Created: 30 September 2007 This Oracle PRO*C file contains callable functions that perform the following tasks: 1) db_connect() connects to the Oracle ERRLOG_OWNER@MCCODEV schema. 2) db_disconnect() disconnects from Oracle. 3) db_insert() inserts data into the Oracle ERRLOG table in the ERRLOG_OWNER@MCCODEV schema. These functions will be called from the C executable "IocLogAndFwdServer" with the intent of loading experimental messaging data into the Oracle ERRLOG table. */ #include #include #include #include #include #define DEBUG 0 #define MOD_SUCCESS 1 #define MOD_FAILURE 0 int g_status; /* JROCK screwing around! will develop error handling further later EXEC SQL INCLUDE SQLCA; #define SQLCA 1 */ /* EXEC SQL BEGIN DECLARE SECTION; */ char SQLSTATE[6]; /* EXEC SQL END DECLARE SECTION; */ long SQLCODE; /* ------------------------------------------------------------ */ /* General error handler */ void sql_error(errmsg) char *errmsg; { char buf[6]; strcpy(buf, SQLSTATE); /* EXEC SQL WHENEVER SQLERROR CONTINUE; */ /* jrock - playing around did not get sqlca working (err message, but it's bs!) sqlca.sqlerrm.sqlerrmc[sqlca.sqlerrm.sqlerrml] = '\0'; printf("\n%s, sqlstate is %s; sqlcaerrm is %s\n\n", errmsg, buf, sqlca.sqlerrm.sqlerrmc); */ if (strncmp(errmsg, "Oracle Error", 12) == 0) { printf("\n%s, sqlstate is %s\n\n", errmsg, buf); } else { printf("\n%s\n\n", errmsg); } printf("Last SQL statement: %.*s\n", oraca.orastxt.orastxtl, oraca.orastxt.orastxtc); if ( DEBUG ) { printf("\nAt or near line number %d\n", oraca.oraslnr); printf("\nCursor Cache Statistics\n------------------------\n"); printf("Maximum value of MAXOPENCURSORS: %d\n", oraca.orahoc); printf("Maximum open cursors required: %d\n", oraca.oramoc); printf("Current number of open cursors: %d\n", oraca.oracoc); printf("Number of cache reassignments: %d\n", oraca.oranor); printf("Number of SQL statement parses: %d\n", oraca.oranpr); printf("Number of SQL statement executions: %d\n", oraca.oranex); } /* EXEC SQL ROLLBACK WORK RELEASE; */ { struct sqlexd sqlstm; sqlstm.sqlvsn = 12; sqlstm.arrsiz = 0; sqlstm.sqladtp = &sqladt; sqlstm.sqltdsp = &sqltds; sqlstm.iters = (unsigned int )1; sqlstm.offset = (unsigned int )5; sqlstm.cud = sqlcud0; sqlstm.sqlest = (unsigned char *)&sqlca; sqlstm.sqlety = (unsigned short)4352; sqlstm.occurs = (unsigned int )0; sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); SQLCODE = sqlca.sqlcode; } g_status = MOD_FAILURE; return; } /* ------------------------------------------------------------ */ int db_connect(server) char server[31]; { int curr_status = 0; g_status = MOD_SUCCESS; char login[100]; char passwd[100]; char user[] = "message_logger"; char cmd[100]; char buff[100]; memset(cmd, '\0', sizeof(cmd)); memset(buff, '\0', sizeof(buff)); memset(passwd, '\0', sizeof(passwd)); memset(login, '\0', sizeof(login)); // set up connection string // get password /* sprintf(cmd, "getPwd %s", user); FILE *fp = popen(cmd, "r"); fgets(buff, sizeof(buff), fp); fclose(fp); // remove trailing '\n' from passwd strncpy(passwd, buff, strlen(buff)-1); strcpy(login, user); sprintf(login, "%s/%s@", user, passwd); strcpy(login, user); strcat(login, "/asorry17cents:@"); strcat(login, server); */ /* FOR ORACLE WALLET SETUP */ strcpy(login, "/@"); strcat(login, server); printf("db connect via ORACLE WALLET:\n"); printf("login=%s\n", login); /* EXEC SQL BEGIN DECLARE SECTION; */ /* EXEC SQL END DECLARE SECTION; */ // END FIXME /* EXEC SQL WHENEVER SQLERROR DO sql_error("CONNECT ERROR"); */ /* EXEC SQL CONNECT :login; */ { struct sqlexd sqlstm; sqlstm.sqlvsn = 12; sqlstm.arrsiz = 4; sqlstm.sqladtp = &sqladt; sqlstm.sqltdsp = &sqltds; sqlstm.iters = (unsigned int )10; sqlstm.offset = (unsigned int )20; sqlstm.cud = sqlcud0; sqlstm.sqlest = (unsigned char *)&sqlca; sqlstm.sqlety = (unsigned short)4352; sqlstm.occurs = (unsigned int )0; sqlstm.sqhstv[0] = ( void *)login; sqlstm.sqhstl[0] = (unsigned int )100; sqlstm.sqhsts[0] = ( int )100; sqlstm.sqindv[0] = ( void *)0; sqlstm.sqinds[0] = ( int )0; sqlstm.sqharm[0] = (unsigned int )0; sqlstm.sqadto[0] = (unsigned short )0; sqlstm.sqtdso[0] = (unsigned short )0; sqlstm.sqphsv = sqlstm.sqhstv; sqlstm.sqphsl = sqlstm.sqhstl; sqlstm.sqphss = sqlstm.sqhsts; sqlstm.sqpind = sqlstm.sqindv; sqlstm.sqpins = sqlstm.sqinds; sqlstm.sqparm = sqlstm.sqharm; sqlstm.sqparc = sqlstm.sqharc; sqlstm.sqpadto = sqlstm.sqadto; sqlstm.sqptdso = sqlstm.sqtdso; sqlstm.sqlcmax = (unsigned int )100; sqlstm.sqlcmin = (unsigned int )2; sqlstm.sqlcincr = (unsigned int )1; sqlstm.sqlctimeout = (unsigned int )0; sqlstm.sqlcnowait = (unsigned int )0; sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); SQLCODE = sqlca.sqlcode; if (sqlca.sqlcode < 0) sql_error("CONNECT ERROR"); } /* EXEC SQL WHENEVER SQLERROR CONTINUE; */ /* EXEC SQL ALTER SESSION SET COMMIT_WRITE='BATCH,NOWAIT'; */ /* EXEC SQL ALTER SESSION SET COMMIT_WRITE='IMMEDIATE,NOWAIT'; */ { struct sqlexd sqlstm; sqlstm.sqlvsn = 12; sqlstm.arrsiz = 4; sqlstm.sqladtp = &sqladt; sqlstm.sqltdsp = &sqltds; sqlstm.stmt = "alter SESSION SET COMMIT_WRITE = 'IMMEDIATE,NOWAIT'"; sqlstm.iters = (unsigned int )1; sqlstm.offset = (unsigned int )51; sqlstm.cud = sqlcud0; sqlstm.sqlest = (unsigned char *)&sqlca; sqlstm.sqlety = (unsigned short)4352; sqlstm.occurs = (unsigned int )0; sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); SQLCODE = sqlca.sqlcode; } curr_status = g_status; return curr_status; } /* ------------------------------------------------------------ */ int db_disconnect() { /* EXEC SQL COMMIT WORK RELEASE; */ { struct sqlexd sqlstm; sqlstm.sqlvsn = 12; sqlstm.arrsiz = 4; sqlstm.sqladtp = &sqladt; sqlstm.sqltdsp = &sqltds; sqlstm.iters = (unsigned int )1; sqlstm.offset = (unsigned int )66; sqlstm.cud = sqlcud0; sqlstm.sqlest = (unsigned char *)&sqlca; sqlstm.sqlety = (unsigned short)4352; sqlstm.occurs = (unsigned int )0; sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); SQLCODE = sqlca.sqlcode; } return MOD_SUCCESS; } /* ------------------------------------------------------------ */ int db_commit() { /* EXEC SQL COMMIT WORK; */ { struct sqlexd sqlstm; sqlstm.sqlvsn = 12; sqlstm.arrsiz = 4; sqlstm.sqladtp = &sqladt; sqlstm.sqltdsp = &sqltds; sqlstm.iters = (unsigned int )1; sqlstm.offset = (unsigned int )81; sqlstm.cud = sqlcud0; sqlstm.sqlest = (unsigned char *)&sqlca; sqlstm.sqlety = (unsigned short)4352; sqlstm.occurs = (unsigned int )0; sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); SQLCODE = sqlca.sqlcode; } return MOD_SUCCESS; } /* ------------------------------------------------------------ */ int db_insert(msglog_id, program_name, facility_name, severity, msg, logServer_ascii_time, app_ascii_time, throttle_ascii_time, app_timestamp_def, msg_code, hostnode, user_name, status, process_name, msg_count, throttle_parameter, commit_flag) /* EXEC SQL BEGIN DECLARE SECTION; */ int msglog_id; /* int logserver_id; */ char program_name[11]; char facility_name[41]; char severity[21]; char msg[681]; char logServer_ascii_time[31]; char app_ascii_time[31]; char throttle_ascii_time[31]; int app_timestamp_def; /* int err_code; */ char msg_code[257]; char hostnode[41]; char user_name[41]; /* int status; */ char status[21]; char process_name[41]; long msg_count; char throttle_parameter[2001]; int commit_flag; /* EXEC SQL END DECLARE SECTION; */ /* EXEC SQL VAR msglog_id IS INTEGER; */ /* EXEC SQL VAR logserver_id IS INTEGER; */ /* EXEC SQL VAR program_name IS STRING(11); */ /* EXEC SQL VAR facility_name IS STRING(41); */ /* EXEC SQL VAR severity IS STRING(21); */ /* EXEC SQL VAR msg IS STRING(681); */ /* EXEC SQL VAR logServer_ascii_time IS STRING(32); */ /* EXEC SQL VAR app_ascii_time IS STRING(32); */ /* EXEC SQL VAR throttle_ascii_time IS STRING(32); */ /* EXEC SQL VAR app_timestamp_def IS INTEGER; */ /* EXEC SQL VAR err_code IS INTEGER; */ /* EXEC SQL VAR msg_code IS STRING(257); */ /* EXEC SQL VAR hostnode IS STRING(41); */ /* EXEC SQL VAR user_name IS STRING(41); */ /* EXEC SQL VAR status IS INTEGER; */ /* EXEC SQL VAR status IS STRING(21); */ /* EXEC SQL VAR process_name IS STRING(41); */ /* EXEC SQL VAR msg_count IS INTEGER; */ /* EXEC SQL VAR throttle_parameter IS STRING(2001); */ { int curr_status = 0; g_status = MOD_SUCCESS; /* =================================================== */ /* EXEC ORACLE OPTION (ORACA=YES); */ oraca.oradbgf = 1; /* enable debug operations */ oraca.oracchf = 1; /* gather cursor cache statistics */ oraca.orastxtf = 3; /* always save the SQL statement */ /* ===================================================== */ /* EXEC SQL WHENEVER SQLERROR DO sql_error("INSERT ERROR"); */ /* default app_time and orig_time - altho this may slow things down */ /* printf ("logServer_ascii_time: %s app_ascii_time: %s\n", logServer_ascii_time, app_ascii_time); */ /* will need this, but for now use the sequence EXEC SQL INSERT INTO errlog (errlog_id, */ /* TESTING THE ERROR REPORTING! */ /* EXEC SQL INSERT INTO message_log (msglog_id,*/ /* EXEC SQL INSERT INTO message_log (msglog_id, program_name, facility_name, severity, msg, logServer_timestamp, app_timestamp, throttle_timestamp, app_timestamp_def, msg_code, hostnode, user_name, status, process_name, msg_count, throttle_parameter, created_by, /o remove?? o/ created_date, /o remove?? o/ ora_timestamp ) VALUES (message_log_seq.nextval, :program_name, :facility_name, :severity, :msg, /o to_timestamp(:logServer_ascii_time, 'DY MON DD HH24:MI:SS.FF YYYY'), o/ to_timestamp(:logServer_ascii_time, 'DD-MON-YYYY HH24:MI:SS.FF'), to_timestamp(:app_ascii_time, 'DD-MON-YYYY HH24:MI:SS.FF'), to_timestamp(:throttle_ascii_time, 'DD-MON-YYYY HH24:MI:SS.FF'), :app_timestamp_def, :msg_code, :hostnode, :user_name, :status, :process_name, :msg_count, :throttle_parameter, 'iocLogMsgServer', sysdate, systimestamp ) /o LOG ERRORS INTO MESSAGE_LOG_ERRORS o/ LOG ERRORS INTO MESSAGE_LOG_ERRORS REJECT LIMIT UNLIMITED; */ { struct sqlexd sqlstm; sqlorat((void **)0, &sqlctx, &oraca); sqlstm.sqlvsn = 12; sqlstm.arrsiz = 15; sqlstm.sqladtp = &sqladt; sqlstm.sqltdsp = &sqltds; sqlstm.stmt = "insert INTO message_log ( msglog_id , program_name , faci\ lity_name , severity , msg , logServer_timestamp , app_timestamp , throttle_ti\ mestamp , app_timestamp_def , msg_code , hostnode , user_name , status , proce\ ss_name , msg_count , throttle_parameter , created_by , created_date , ora_tim\ estamp ) VALUES ( message_log_seq . nextval , :b0 , :b1 , :b2 , :b3 , to_times\ tamp ( :b4 , 'DD-MON-YYYY HH24:MI:SS.FF' ) , to_timestamp ( :b5 , 'DD-MON-YYYY\ HH24:MI:SS.FF' ) , to_timestamp ( :b6 , 'DD-MON-YYYY HH24:MI:SS.FF' ) , :b7 ,\ :b8 , :b9 , :b10 , :b11 , :b12 , :b13 , :b14 , 'iocLogMsgServer' , sysdate , \ systimestamp ) LOG ERRORS INTO MESSAGE_LOG_ERRORS REJECT LIMIT UNLIMITED "; sqlstm.iters = (unsigned int )1; sqlstm.offset = (unsigned int )96; sqlstm.cud = sqlcud0; sqlstm.sqlest = (unsigned char *)&sqlca; sqlstm.sqlety = (unsigned short)4352; sqlstm.occurs = (unsigned int )0; sqlstm.sqhstv[0] = ( void *)program_name; sqlstm.sqhstl[0] = (unsigned int )11; sqlstm.sqhsts[0] = ( int )0; sqlstm.sqindv[0] = ( void *)0; sqlstm.sqinds[0] = ( int )0; sqlstm.sqharm[0] = (unsigned int )0; sqlstm.sqadto[0] = (unsigned short )0; sqlstm.sqtdso[0] = (unsigned short )0; sqlstm.sqhstv[1] = ( void *)facility_name; sqlstm.sqhstl[1] = (unsigned int )41; sqlstm.sqhsts[1] = ( int )0; sqlstm.sqindv[1] = ( void *)0; sqlstm.sqinds[1] = ( int )0; sqlstm.sqharm[1] = (unsigned int )0; sqlstm.sqadto[1] = (unsigned short )0; sqlstm.sqtdso[1] = (unsigned short )0; sqlstm.sqhstv[2] = ( void *)severity; sqlstm.sqhstl[2] = (unsigned int )21; sqlstm.sqhsts[2] = ( int )0; sqlstm.sqindv[2] = ( void *)0; sqlstm.sqinds[2] = ( int )0; sqlstm.sqharm[2] = (unsigned int )0; sqlstm.sqadto[2] = (unsigned short )0; sqlstm.sqtdso[2] = (unsigned short )0; sqlstm.sqhstv[3] = ( void *)msg; sqlstm.sqhstl[3] = (unsigned int )681; sqlstm.sqhsts[3] = ( int )0; sqlstm.sqindv[3] = ( void *)0; sqlstm.sqinds[3] = ( int )0; sqlstm.sqharm[3] = (unsigned int )0; sqlstm.sqadto[3] = (unsigned short )0; sqlstm.sqtdso[3] = (unsigned short )0; sqlstm.sqhstv[4] = ( void *)logServer_ascii_time; sqlstm.sqhstl[4] = (unsigned int )32; sqlstm.sqhsts[4] = ( int )0; sqlstm.sqindv[4] = ( void *)0; sqlstm.sqinds[4] = ( int )0; sqlstm.sqharm[4] = (unsigned int )0; sqlstm.sqadto[4] = (unsigned short )0; sqlstm.sqtdso[4] = (unsigned short )0; sqlstm.sqhstv[5] = ( void *)app_ascii_time; sqlstm.sqhstl[5] = (unsigned int )32; sqlstm.sqhsts[5] = ( int )0; sqlstm.sqindv[5] = ( void *)0; sqlstm.sqinds[5] = ( int )0; sqlstm.sqharm[5] = (unsigned int )0; sqlstm.sqadto[5] = (unsigned short )0; sqlstm.sqtdso[5] = (unsigned short )0; sqlstm.sqhstv[6] = ( void *)throttle_ascii_time; sqlstm.sqhstl[6] = (unsigned int )32; sqlstm.sqhsts[6] = ( int )0; sqlstm.sqindv[6] = ( void *)0; sqlstm.sqinds[6] = ( int )0; sqlstm.sqharm[6] = (unsigned int )0; sqlstm.sqadto[6] = (unsigned short )0; sqlstm.sqtdso[6] = (unsigned short )0; sqlstm.sqhstv[7] = ( void *)&app_timestamp_def; sqlstm.sqhstl[7] = (unsigned int )4; sqlstm.sqhsts[7] = ( int )0; sqlstm.sqindv[7] = ( void *)0; sqlstm.sqinds[7] = ( int )0; sqlstm.sqharm[7] = (unsigned int )0; sqlstm.sqadto[7] = (unsigned short )0; sqlstm.sqtdso[7] = (unsigned short )0; sqlstm.sqhstv[8] = ( void *)msg_code; sqlstm.sqhstl[8] = (unsigned int )257; sqlstm.sqhsts[8] = ( int )0; sqlstm.sqindv[8] = ( void *)0; sqlstm.sqinds[8] = ( int )0; sqlstm.sqharm[8] = (unsigned int )0; sqlstm.sqadto[8] = (unsigned short )0; sqlstm.sqtdso[8] = (unsigned short )0; sqlstm.sqhstv[9] = ( void *)hostnode; sqlstm.sqhstl[9] = (unsigned int )41; sqlstm.sqhsts[9] = ( int )0; sqlstm.sqindv[9] = ( void *)0; sqlstm.sqinds[9] = ( int )0; sqlstm.sqharm[9] = (unsigned int )0; sqlstm.sqadto[9] = (unsigned short )0; sqlstm.sqtdso[9] = (unsigned short )0; sqlstm.sqhstv[10] = ( void *)user_name; sqlstm.sqhstl[10] = (unsigned int )41; sqlstm.sqhsts[10] = ( int )0; sqlstm.sqindv[10] = ( void *)0; sqlstm.sqinds[10] = ( int )0; sqlstm.sqharm[10] = (unsigned int )0; sqlstm.sqadto[10] = (unsigned short )0; sqlstm.sqtdso[10] = (unsigned short )0; sqlstm.sqhstv[11] = ( void *)status; sqlstm.sqhstl[11] = (unsigned int )21; sqlstm.sqhsts[11] = ( int )0; sqlstm.sqindv[11] = ( void *)0; sqlstm.sqinds[11] = ( int )0; sqlstm.sqharm[11] = (unsigned int )0; sqlstm.sqadto[11] = (unsigned short )0; sqlstm.sqtdso[11] = (unsigned short )0; sqlstm.sqhstv[12] = ( void *)process_name; sqlstm.sqhstl[12] = (unsigned int )41; sqlstm.sqhsts[12] = ( int )0; sqlstm.sqindv[12] = ( void *)0; sqlstm.sqinds[12] = ( int )0; sqlstm.sqharm[12] = (unsigned int )0; sqlstm.sqadto[12] = (unsigned short )0; sqlstm.sqtdso[12] = (unsigned short )0; sqlstm.sqhstv[13] = ( void *)&msg_count; sqlstm.sqhstl[13] = (unsigned int )4; sqlstm.sqhsts[13] = ( int )0; sqlstm.sqindv[13] = ( void *)0; sqlstm.sqinds[13] = ( int )0; sqlstm.sqharm[13] = (unsigned int )0; sqlstm.sqadto[13] = (unsigned short )0; sqlstm.sqtdso[13] = (unsigned short )0; sqlstm.sqhstv[14] = ( void *)throttle_parameter; sqlstm.sqhstl[14] = (unsigned int )2001; sqlstm.sqhsts[14] = ( int )0; sqlstm.sqindv[14] = ( void *)0; sqlstm.sqinds[14] = ( int )0; sqlstm.sqharm[14] = (unsigned int )0; sqlstm.sqadto[14] = (unsigned short )0; sqlstm.sqtdso[14] = (unsigned short )0; sqlstm.sqphsv = sqlstm.sqhstv; sqlstm.sqphsl = sqlstm.sqhstl; sqlstm.sqphss = sqlstm.sqhsts; sqlstm.sqpind = sqlstm.sqindv; sqlstm.sqpins = sqlstm.sqinds; sqlstm.sqparm = sqlstm.sqharm; sqlstm.sqparc = sqlstm.sqharc; sqlstm.sqpadto = sqlstm.sqadto; sqlstm.sqptdso = sqlstm.sqtdso; sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); SQLCODE = sqlca.sqlcode; if (sqlca.sqlcode < 0) sql_error("INSERT ERROR"); } if ( commit_flag ) { /* EXEC SQL COMMIT WORK; */ { struct sqlexd sqlstm; sqlorat((void **)0, &sqlctx, &oraca); sqlstm.sqlvsn = 12; sqlstm.arrsiz = 15; sqlstm.sqladtp = &sqladt; sqlstm.sqltdsp = &sqltds; sqlstm.iters = (unsigned int )1; sqlstm.offset = (unsigned int )171; sqlstm.cud = sqlcud0; sqlstm.sqlest = (unsigned char *)&sqlca; sqlstm.sqlety = (unsigned short)4352; sqlstm.occurs = (unsigned int )0; sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn); SQLCODE = sqlca.sqlcode; if (sqlca.sqlcode < 0) sql_error("INSERT ERROR"); } } /* EXEC SQL WHENEVER SQLERROR CONTINUE; */ curr_status = g_status; return curr_status; }