I ve written a procedure which reads data from data file and inserts it in to a table in the d/b
Now ive given all the cols in my tables as not null(company rule)..lol
Now the data file contains null data at some places...
Now Ive made it clear in the proc that if i find a null data ,replace it with ' '.
But still it doesn't :(
I even tried giving the default value for each col as ' '.
Even that doesn't work
pls help

Any kinda suggestion is invited.
thanx a lottttttttt