Skip to Content
0
Former Member
May 30, 2011 at 11:42 AM

handle null value in char infoobject -data type DATE(ora-01722 invalid num)

102 Views

Hi,

We have a DSO with a info object in the Data fields. The char info object has the data type DATE and most often it has the null value. but some times it has data in it.

When ever we were trying to run a report on the DSO it throws a error as ORA- 01722 INVALID NUMBER.

we tried editing PSA data and placing 00000000 for null values - and had a message invalid date.

suggestions pls

Regards.