How to pass null values
707502Aug 12 2010 — edited Sep 6 2010I am working on asp.Net application with the backend in Oracle. I am using ODP.Net to interact with the oracle server.
I have written oracle store procedure to do DML Operation.
In oracle tables the data type of all my Primary Key and Foreing Key tables is
Number(12). At the fron end (in C#), I alwasy declare a long for any of the foreign/Primary key
Like:
long PK;
When there is a need to insert null value in the foreign key, I face problem as we can not assign null values to int/long.
What to do?
I wonder why it is so that we can not assign null values to INT/LONGs in C#