Skip to Content
May 29, 2014 at 10:06 AM

'ORA-01722: Invalid Number' error while Running a Query



I'm trying to run a query built on a DSO. The DSO has a field 'Start Date'. This Start Date InfoObject has a reference Char as 0DATE.

This Start Field has blank values due to which I'm getting the ORA-01722 error. I came across many threads with same topic of discussion. As mentioned in one of the Threads I have written a program to update 'Start Date' with 00000000. The code wriiten is "UPDATE /BIC/AZ_MONINV00 SET /BIC/ZSTR_DTE = '00000000' where /BIC/ZSTR_DTE = ' '.

Now when I see the data in the active data table of DSO the blank value is replaced with '00000000'.

But If I right click on the DSO click on display data the 'Start Date' field is blank. And now the Query also gets executed without any error. But in the output of the query the 'Start Date' Field has "#" values.

Can anyone suggest on how can I make these "#" values appear as 00000000 in the report?