Re: Oracle Error 1858 in BO: against a partition view

On Thu, 29 Jan 1998 20:33:43 -0600, "C.W. Lambert" <CWLAMBERT_at_prodigy.net> wrote:
I also think that must be a formating problem. oracle is not very gentil with wrong date formats. that is not only a problem of BO. check out the date variale in oracle (NLS_DATE_xxxxx). You can set this enviroment variable hard, for every database connect - if the error still exists.

Adrian Fischer
af_at_ibm.net

>You have a date format problem between the way Bus. Obj. is formating a
>date and the format Oracle expects. Start there.
>
>Good Luck,
>
>
>Krishna K. Kurup wrote:
>>
>> We have a Warehouse running on Oracle 7.3.3 with BO as the front end
>> OLAP tool.
>>
>> Has anyone seen error ORA-01858 while querying with Business Objects
>> against a partition view with enabled partitioned constraints (on DATE).
>>
>> Surprisingly the query runs fine when run straight against the database.
>> Its through BO which is giving the error message. If you disable the
>> constraint, BO returns the result. Its quite baffling.
>>
>> Actual Message:
>>
>> error message "ORA-01858: a non-numeric character was found where a
>>
>> numeric was expected: -1858".
>>
>> thanks
>> Krishna
>> krishnak_at_kna.com
Received on Tue Feb 10 1998 - 00:00:00 CET