APEX

Hi -

We have 3.2.1 installed on 11gr2 with OHS configured. The OS is RHEL 5.4

When I attempt to upgrade to 4.0, I get the following error a second after the apexins.sql script starts:


Application Express installation requires the Oracle XML Database database
component.
begin
*
ERROR at line 1:
ORA-00900: invalid SQL statement
ORA-06512: at line 4

And the script stops there.



When I check, XDB seems to be fine:

Connected.
SQL> select 1 from all_users where username = 'XDB';

1
----------
1

SQL> desc RESOURCE_VIEW
Name Null? Type
----------------------------------------- -------- ----------------------------
RES XMLTYPE(XMLSchema "http://xm
lns.oracle.com/xdb/XDBResour
ce.xsd" Element "Resource")
ANY_PATH VARCHAR2(4000)
RESID RAW(16)

SQL>


Any insight into what may be causing this error would be much appreciated.

Thanks,
Scott