#include "include.h"EXEC SQL INCLUDE SQLCA;
EXEC SQL INCLUDE ORACA.H;
EXEC ORACLE OPTION(RELEASE_CURSOR=YES);
int main()
{
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR thedate[20];
EXEC SQL END DECLARE SECTION;
if (ConnectDB() == -1)
{
printf("module *** ConnectDB Error.\n");
return SNY_NOTOK;
}
EXEC SQL WHENEVER SQLERROR GOTO error;
EXEC SQL WHENEVER NOT FOUND GOTO notFound;
EXEC SQL DECLARE cur CURSOR FOR
SELECT time_end FROM log_ml_sp ORDER BY name; EXEC SQL OPEN cur;
memset((void*)&thedate, 0, sizeof(thedate));
EXEC SQL FETCH cur INTO :thedate; while(sqlca.sqlcode==0)
{
printf("date:%s\n", thedate.arr);
memset((void*)&thedate, 0, sizeof(thedate));
EXEC SQL FETCH cur INTO :thedate;
}
notFound:
EXEC SQL CLOSE cur;
printf("is ok!\n\n");
if (CloseDB() == -1)
{
printf("module *** CloseDB Error.\n");
return SNY_NOTOK;
}
return 0;
error:
printf("\nError: %.70s \n",sqlca.sqlerrm.sqlerrmc);
if (CloseDB() == -1)
{
printf("module *** CloseDB Error.\n");
return SNY_NOTOK;
}
return 0;
}
EXEC SQL INCLUDE ORACA.H;
EXEC ORACLE OPTION(RELEASE_CURSOR=YES);
int main()
{
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR thedate[20];
EXEC SQL END DECLARE SECTION;
if (ConnectDB() == -1)
{
printf("module *** ConnectDB Error.\n");
return SNY_NOTOK;
}
EXEC SQL WHENEVER SQLERROR GOTO error;
EXEC SQL WHENEVER NOT FOUND GOTO notFound;
EXEC SQL DECLARE cur CURSOR FOR
SELECT time_end FROM log_ml_sp ORDER BY name; EXEC SQL OPEN cur;
memset((void*)&thedate, 0, sizeof(thedate));
EXEC SQL FETCH cur INTO :thedate; while(sqlca.sqlcode==0)
{
printf("date:%s\n", thedate.arr);
memset((void*)&thedate, 0, sizeof(thedate));
EXEC SQL FETCH cur INTO :thedate;
}
notFound:
EXEC SQL CLOSE cur;
printf("is ok!\n\n");
if (CloseDB() == -1)
{
printf("module *** CloseDB Error.\n");
return SNY_NOTOK;
}
return 0;
error:
printf("\nError: %.70s \n",sqlca.sqlerrm.sqlerrmc);
if (CloseDB() == -1)
{
printf("module *** CloseDB Error.\n");
return SNY_NOTOK;
}
return 0;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货