esql 에서 text type 에 글을 올리려고 합니다..
..............................................................
EXEC SQL BEGIN DECLARE SECTION;
char SQLQ[BUFSIZ];
loc_t desc;
EXEC SQL END DECLARE SECTION;
desc.loc_loctype = clobSize;
desc.loc_buffer = cddFormat.sym_desc;
desc.loc_size = strlen(cddFormat.sym_desc) + 1;
sprintf(SQLQ, "INSERT INTO %s VALUES('%s', %d , '%s', '%s', '%s', %d, %d, ?)", cTable, cddFormat.cdd_id, cddFormat.seq_no, cddFormat.rel_id, cddFormat.rel_sym_na, cddFormat.cdd_sym_na, cddFormat.cdd_max_val, cddFormat.cdd_min_val);
EXEC SQL prepare cddF_id FROM : SQLQ;
EXEC SQL execute cddF_id USING :desc;
..............................................................
이렇게 작성했는데..
런타임 에러가 납니다.
sqlcode:-450 (-450 : Illegal ESQL locator, or uninitialized blob variable in 4GL.)
text type 에 데이터를 넣으려면 어떻게 해야 하는거죠 알려주셔용.~~
|