Hi,
version 11.2.0.3
Have a view which want to turn into a mview
However when try create the mview get message below.
Some of columns in view are null
ORA-01723 zero length columns are not allowed
tried cast(nvl(dw.convert_to_guid(id),'7') as nvarchar2(255)) but still get message
Would have thought cast(col as nvarchar2(255) would have been enough as some columns in the view are null for some rows and valid for them to be null
Thanks