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

Is 'OCI_ATTR_PARSE_ERROR_OFFSET' what you are looking for.

Cheers,
Stuart.

Torsten Reichert wrote:

> 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:58:15 CDT