Hang at sqlcxt

From: svt <patpat_at_unforgettable.com>
Date: Mon, 20 Sep 1999 15:28:35 +0800
Message-ID: <37e5e229@news02.imsbiz.com>

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;
  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");
}

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 - 02:28:35 CDT