VB.NET pass null SQL date as time in PL/SQL -

VB.NET pass null SQL date as time in PL/SQL -

i writing vb.net application moves info ms sql database table oracle database table.

a record in ms sql db has null date. oracle db table column set allow nulls. when run vb.net application , step through app, works fine until record null date. vb.net shows null date '12:00 am' no date, time.

the oracle error is: ora-01847: day of month must between 1 , lastly day of month

here sql pull in date ms sql db:

convert(varchar(10),date_column,101) end 'date_column'

here pl/sql have inserting oracle db:

to_date('" & tmp_date_column & "','mm/dd/yyyy')

looks tmp_something_date variable of type date. problem cannot store null/nothing values in date variable. if seek assign date nothing, assigned date.minvalue, equals #12:00:00 am#. either need nullable(of date) or utilize datatable column values directly.

sql vb.net plsql