OCI (in C) : detect attribute causing SQL-statement to fail

From: Torsten Reichert <Torsten.Reichert_at_gmx.net>
Date: Wed, 26 Sep 2001 14:15:58 +0200
Message-ID: <3BB1C6FE.40204@gmx.net>

Hello experts

A failing large SQL-statement like the one below gives a general error-message like variabel not bound, or inconsistent type.

Is there any way to decide which attribute causes the failure ?

Thank you for your help

"INSERT INTO tabname ("
"K001,"
"K002,"
"K003,"
"F003,"
"F004,"
"P012,"
"P713,"
"P014,"
"P715,"
"P016,"
"P717,"
"P018,"
"P719,"
"P020,"
"P721,"
"P022,"
"P723,"
"P024,"
"P708,"
"P729,"
"P730,"
"F030,"
"F031,"
"F032,"
"F033,"
"F038,"
"F078,"
"F079,"
"F099,"
"F100"
")"
" VALUES ("
":K001,"
":K002,"
":K003,"
":F003,"
":F004,"
"TO_DATE(:P012,'YYYYMMDD'),"
":P713,"
":P014,"
":P715,"
":P016,"
":P717,"
":P018,"
":P719,"
":P020,"
":P721,"
":P022,"
":P723,"
":P024,"
":P708,"
":P729,"
":P730,"
":F030,"
":F031,"
":F032,"
":F033,"
":F038,"
"TO_DATE(:F078,'YYYYMMDD'),"
"TO_DATE(:F079,'YYYYMMDD'),"
":F099,"
"TO_DATE(:F100,'YYYYMMDD')"
")";
":P729,"
":P730,"
":F030,"
":F031,"
":F032,"
":F033,"
":F038,"
"TO_DATE(:F078,'YYYYMMDD'),"
"TO_DATE(:F079,'YYYYMMDD'),"
":F099,"
"TO_DATE(:F100,'YYYYMMDD')"
")";
Received on Wed Sep 26 2001 - 07:15:58 CDT