From: "Michel Cadot" Subject: Re: sql Date: 2000/08/08 Message-ID: <8mp1io$698$1@s1.read.news.oleane.net>#1/1 References: <398FFAED.ADD6E59D@gazeta.pl> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Complaints-To: abuse@oleane.net X-Trace: s1.read.news.oleane.net 965740952 6440 195.101.229.231 (8 Aug 2000 13:22:32 GMT) Organization: Guest of France Telecom Oleane's newsreading service Reply-To: "Michel Cadot" NNTP-Posting-Date: Tue, 8 Aug 2000 13:22:32 +0000 (UTC) Newsgroups: comp.databases.oracle.misc Because of the space in first position: v815> select to_char(257,'0XXXXX') from dual; TO_CHAR ------- 000101 1 row selected. v815> select hextoraw(to_char(257,'0XXXXX')) from dual; select hextoraw(to_char(257,'0XXXXX')) from dual * ERROR at line 1: ORA-01465: invalid hex number v815> v815> select hextoraw(ltrim(to_char(257,'0XXXXX'))) from dual; HEXTORAW -------- 000101 1 row selected. -- Have a nice day Michel Marcin Buchwald a écrit dans le message : 398FFAED.ADD6E59D@gazeta.pl... > > select to_char(257,'0XXXXX') from dual; > select hextoraw('000101') from dual; > select hextoraw(to_char(257,'0XXXXX')) from dual; > > what is the reason that third statement fails ?