답변 감사드립니다. 헌데... 이룬 아래와 같은 에러 메시지를 출력하는데...

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;

> > }

> >