- 论坛徽章:
- 0
|
int
ex_memproc (void *connetiont, char *cmdbuff, char *Retbuff1, int Retlen1, char *
Retbuff, int Retlen, int *retsultint)
{
$char selstmt[1024];
$char RetBuff[1024];
$char RetBuff1[1024];
int ret;
$int RetCode;
DEBUGLOG (ZFMMLOG, "function ex_memproc cmdbuff:=%s", cmdbuff);
sprintf (selstmt, "%s", cmdbuff);
$prepare stmt_1 from $selstmt;
ret = err_chk (" repare" ;
if (ret < 0)
return -1;
$declare c cursor for stmt_1;
ret
= err_chk ("Declare cursor" ;
if (ret < 0)
return -1;
$open c;
ret = err_chk ("Open cursor" ;
if (ret < 0)
return -1;
$fetch c into:RetCode,:RetBuff,:RetBuff1;
if (SQLCODE == SQLNOTFOUND)
return -1;
else
{
ret = err_chk ("Fetch" ;
if (ret < 0)
return -1;
}
$close c;
ret = err_chk ("Close cursor" ;
if (ret < 0)
return -1;
memcpy (Retbuff, RetBuff, sizeof (RetBuff));
memcpy (Retbuff1, RetBuff1, sizeof (RetBuff1));
*retsultint = RetCode;
return 1;
} |
|