To_char problem

[Quoted] [Quoted] I've got a probleme when I try to access some data by using "to_char" [Quoted] function in the "WHERE" clause of my request.

For example, when I write the following request, it works : SQL> select ';' || to_char(obj_id0) || ';' from invoice_formats_buf_t where obj_id0=225936449496832965;
The result is :
';'||TO_CHAR(OBJ_ID0)||';'

But with this one, it doesn't :
SQL> select ';' || to_char(obj_id0) || ';' from invoice_formats_buf_t where to_char(obj_id0)='225936449496832965'; The result is :
no rows selected

For information, the type of the selected field is NUMBER. You can find here a description of the table:
SQL> desc invoice_formats_buf_t

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 OBJ_ID0                                            NUMBER
 REC_ID                                             NUMBER
 BUFFER_BUF                                         BLOB

Has anyone an idea concerning the origin of this strange behaviour.

Thanks,

Cédric Calentier. Received on Thu Feb 10 2005 - 17:50:48 CET