-
HI,
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
-
pls show your table and proc, it will be easier to find why it doesn't work ;))
-
Try using a string like 'NULL' or 'EMPTY'. It is an ugly fix, but this is not really a technical issue.
Why are all columns NOT NULL when it does not reflect the state of the business?
Good luck.
-
I still cannot get throgh with this...
value:=LTRIM(RTRIM(value,' '),' ');
if value=null then
value:=' ';
end if;
I ve given this to replace null with empty strings
thanx
-
test using :
value := nvl(value,' ')
BTW : testing nullity using '= null' is not recommended, you should use 'is null'
-
THANXXXXXXXXA LOTT GUYSSS
I dunno how to thank u guys...
thanx again
-
U can use NVL(abc,' ') or give default values to the columns
-
U can use NVL(abc,' ') or give default values to the columns