답변 감사드립니다. 헌데... 이룬 아래와 같은 에러 메시지를 출력하는데...
immediate 문법이 잘못된건가요.???
NOTICE: The ':' operator is deprecated. Use exp(x) instead.
This operator will be removed in a future release.
NOTICE: The ':' operator is deprecated. Use exp(x) instead.
This operator will be removed in a future release.
NOTICE: The ':' operator is deprecated. Use exp(x) instead.
This operator will be removed in a future release.
NOTICE: The ':' operator is deprecated. Use exp(x) instead.
This operator will be removed in a future release.
NOTICE: The ':' operator is deprecated. Use exp(x) instead.
This operator will be removed in a future release.
NOTICE: The ':' operator is deprecated. Use exp(x) instead.
This operator will be removed in a future release.
sql error 'ERROR: parser: parse error at or near ":"' in line 198.
> > void dbINSERT_IN(readBuff, nbytes)
> > char *readBuff;
> > int nbytes;
> > {
> >
> > EXEC SQL BEGIN DECLARE SECTION;
> >
> > char sqlcmd[500];
> >
> > EXEC SQL END DECLARE SECTION;
> >
> > char month[3];
> >
> > IN_INFO_DB inInfoDb;
> >
> > memset(&inInfoDb, 0x00, sizeof(inInfoDb));
> > memset(month, 0x00, sizeof(month));
> > memset(sqlcmd, 0x00, sizeof(sqlcmd));
> >
> > str_offset_copy_IN(&inInfoDb, readBuff, nbytes, month);
> >
> > EXEC SQL CONNECT TO 'test';
> > sprintf(sqlcmd, "INSERT INTO In%s112(status,ktCode,pfCode,outktCode,outpfCode,acdTime,
> se
> > rverTi
> > me,ddd,telNo) VALUES(:%s, :%s, :%s, :%s, :%s, :%s, :%s, :%s, :%s)", month, inInfoDb.statusPart
> ,
> >
> > inInfoDb.KTregPart, inInfoDb.chungRegPart, inInfoDb.outKTregPart, inInfoDb.outChungRegPart, in
> In
> >
> > foDb.acdTime, inInfoDb.Servtime, inInfoDb.regionNo, inInfoDb.telNo);
> >
> > EXEC SQL EXECUTE IMMEDIATE :sqlcmd;
> >
> > EXEC SQL COMMIT;
> >
> > return;
> > }
> >
|