Skip to Main Content
Forums

SQL & PL/SQL

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!

NULL in a number field

userLynxAug 2 2010 — edited Aug 6 2010
I am using VB.net to insert (bulk) records into an Oracle table. Some of the fields are defined as number in ORACLE. [eg: ACR_ELEC_CAP_OBLIGATION NUMBER(12,5) Nullable is Yes ]

In my VB.net I am deliberately setting this to DBNULL if the value is 0. I want to default this in the database to NULL and not 0.

Yet, when I insert to the database, the value of this field is 0 and not null.

Could the bulk insert process override my explicit NULL set back to 0?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2010
Added on Aug 2 2010
4 comments
3,350 views