DB-Version: 10.2.0.3
PROC-Verison:
[root@vOraDB c]# proc version
Pro*C/C++: Release 10.2.0.3.0 - Production on Tue Sep 4 12:41:19 2012
When I insert a row with proc-sql I get a error-message, that say's, theat the coloumn "einheit_dim" is null:
ORA-01400: cannot insert NULL into ("ESW"."ARTIKEL_BEW"."EINHEIT_DIM")]
But when I printf this column, the value is not null:
Value of einheit_dim:
Value, Lengh.
DEBUG: [kg][2]
printf("DEBUG: [%s][%d]\n",einheit_dim.arr,strlen(einheit_dim.arr));
printf("DEBUG: [%d][%d][%d]\n",artikel_grp,artikel_ugrp,artikel_lfdnr);
EXEC SQL INSERT INTO ARTIKEL_BEW
( ARTIKEL_GRP, ARTIKEL_UGRP, ARTIKEL_LFDNR,
BU_NR, BU_DAT,
BELEG_NR,
BELEG_DAT,
PER_DAT,
BU_SYMBOL, EINHEIT_DIM, EINHEIT_FAKTOR,
LAGER_ORT,
KST, KOA, MAT_KONTO_NR,
SH_KZ, BEW_MENGE, BEW_WERT,
ABC_BEWERTUNG,
BEARB_KZ, BEARB_DAT )
VALUES ( :artikel_grp, :artikel_ugrp, :artikel_lfdnr,
:bu_nr, TRUNC ( SYSDATE, 'DD' ),
TO_CHAR ( ARTIKEL_BEW_SEQ.NEXTVAL ),
TO_DATE ( :tag_abr, 'YYYYMMDD' ),
TO_DATE ( :per_dat, 'YYYYMM' ),
'VW', :einheit_dim, :einheit_faktor,
:lager_ort,
:kst, :koa, :labu_mat_konto_nr,
'H', :bu_menge, :bu_menge * :fix_preis,
:abc_bewertung,
USER, SYSDATE );
printf("DEBUG: [%d][%s]\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
Output:
DEBUG: [kg][2]
DEBUG: [56][1][560]
DEBUG: [-1400][ORA-01400: cannot insert NULL into ("ESW"."ARTIKEL_BEW"."EINHEIT_DIM")]
Does anybody know, hwo to solve this error?