Oracle Database Express Edition (XE)

Robert,

when I run the following piece of code

    htp.init;
    begin
        nm(1) := 'REQUEST_CHARSET';
        vl(1) := 'AL32UTF8';
        nm(2) := 'REQUEST_IANA_CHARSET';
        vl(2) := 'UTF-8';
        owa.init_cgi_env( 2, nm, vl );
    end;

I get an exception:

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 328
ORA-06512: at "SYS.HTP", line 7

When I comment out htp.init; it works:

    --htp.init;
    begin
        nm(1) := 'REQUEST_CHARSET';
        vl(1) := 'AL32UTF8';
        nm(2) := 'REQUEST_IANA_CHARSET';
        vl(2) := 'UTF-8';
        owa.init_cgi_env( 2, nm, vl );
    end;

The code is from the marvel team to export a html db application.

It works on a standard html db installation with mod_plsql but it throws the exception on XE.
htp.init is called implicitly in the initialization section of the package htp. Thus calling it twice throws an error.

Thanks,
~Dietmar.