DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

1406 (truncation) error

397575Jul 28 2003 — edited Nov 20 2005

If buffer length specified by OCIDefineByPos is less than the actual data length, the subsequent OCIStmtFetch fails with 1406 error. In Oracle 7 API, the ODEFIN/OFEN sequence would actually return truncated data, that is, OFEN would return whatever size (0-n) was specified in the ODEFIN. Is there a way to override with OCI 8i/9i calls, so that the truncated data (0-n characters) is returned?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2005

Added on Jul 28 2003

#oracle-call-interface-oci

2 comments

2,420 views