Hang at sqlcxt
From: svt <patpat_at_unforgettable.com>
Date: Mon, 20 Sep 1999 15:28:35 +0800
Message-ID: <37e5e229_at_news02.imsbiz.com>
[Quoted] Hi all,
}
sqlcxt(&ctx1, &sqlctx, &sqlstm, &sqlfpn);
}
Date: Mon, 20 Sep 1999 15:28:35 +0800
Message-ID: <37e5e229_at_news02.imsbiz.com>
[Quoted] Hi all,
In my .pc file, I try to call a store procedure, select_row
EXEC SQL CALL select_row(:ReadRecPerTrans);
and the pro*C++ compiler give me the following .c code
// Prototypes
extern "C" {
void sqlcxt (void **, unsigned long *,
struct sqlexd *, const struct sqlcxp *); void sqlcx2t(void **, unsigned long *,
struct sqlexd *, const struct sqlcxp *);
void sqlbuft(void **, char *); void sqlgs2t(void **, char *); void sqlorat(void **, unsigned long *, void *);
}
{
struct sqlexd sqlstm;
sqlstm.sqlvsn = 10; sqlstm.arrsiz = 1; sqlstm.sqladtp = &sqladt; sqlstm.sqltdsp = &sqltds; [Quoted] sqlstm.stmt = "call select_row(:b0)"; sqlstm.iters = (unsigned int )1; sqlstm.offset = (unsigned int )92; sqlstm.cud = sqlcud0; sqlstm.sqlest = (unsigned char *)&sqlca; sqlstm.sqlety = (unsigned short)256; sqlstm.occurs = (unsigned int )0; sqlstm.sqhstv[0] = ( void *)&ReadRecPerTrans; sqlstm.sqhstl[0] = (unsigned int )4; 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.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(&ctx1, &sqlctx, &sqlstm, &sqlfpn);
/*****************hang*********************/if (sqlca.sqlcode < 0) sql_error("ORACLE error--\n");
}
[Quoted] [Quoted] the program hangs when calling sqlcxt, it also hang at this call when I try
EXEC CONNECT
Please help.
Received on Mon Sep 20 1999 - 09:28:35 CEST