Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-30205 in utl_encode.mimeheader_decode

ORA-30205 in utl_encode.mimeheader_decode

From: Lothar Armbruester <lothar.armbruester_at_t-online.de>
Date: Tue, 9 Mar 2004 21:43:26 +0100
Message-ID: <PM0003D538D5723CD3@hades.none.local>


Hello out there,

I'm trying to use utl_encode.mimeheader_decode to decode email headers but it gives me ORA-30205.
When I do the following:

select utl_encode.mimeheader_decode('=?ISO-8859-1?B?T3JkZXIg=?=') from dual;

I get:

select utl_encode.mimeheader_decode('=?ISO-8859-1?B?T3JkZXIg=?=') from dual

       *

ERROR at line 1:

ORA-30205: invalid Character set
ORA-06512: at "SYS.UTL_ENCODE", line 218
ORA-06512: at "SYS.UTL_ENCODE", line 323

Obviously Oracle does not recognize ISO-8859-1 as valid characterset. But this is the way the examples in the docs are.

Wenn I do:

select utl_encode.mimeheader_decode('=?WE8ISO8859P1?B?T3JkZXIg=?=') from dual;

I get the desired result:

Order

So the question is: How do I get Oracle to recognize the characters set the way they are used in emails?

I use Oracle 10.1.0.2.0 on Solaris 9.

Many thanks in advance,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de
Received on Tue Mar 09 2004 - 14:43:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US