EXEC SQL BEGIN DECLARE SECTION;
    char    dbFromDate[MAX_DATE_LEN];
    char    dbToDate[MAX_DATE_LEN];

    short   ind_dbToDate;

    EXEC SQL VAR dbFromDate IS STRING;
    EXEC SQL VAR dbToDate IS STRING;
EXEC SQL END DECLARE SECTION;

sprintf(dbFromDate,"%s",pServiceRecord->itemFrom);
sprintf(dbToDate,"%s",pServiceRecord->itemTo);

EXEC SQL
insert into MYDATES (from_date, to_date)
             values (TO_DATE(:dbFromDate,:dbOraDateFmt),
                     TO_DATE(:dbToDate,:dbOraDateFmt));