Precompilers and OCI (MOSC)

MOSC Banner

using NULL in OCIBindByPos()

edited Jun 10, 2015 12:00PM in Precompilers and OCI (MOSC) 2 commentsAnswered ✓

I now have doubts whether I'm using the right mechanism to set NULL values in OCIBindByPos().

What is the correct contents of a passed SQL_STR when one intends to set the respective column (INTEGER,DATE,VARCHAR) to NULL?

One might say "don't set it, skip it", but for symmetry reasons I'm always doing an INSERT on the full bind list and it would be very difficult

to fish out only those columns that are really set to something != NULL.

Help appreciated. Thanks.

Christoph

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center