external package:rdbms_olap

[dba123123]

Can somebody provide the check list on how to configure the server side to allow the user call up external package such as rdbms_olap?

I run the following code and ended up with the error:

DECLARE
my_id NUMBER;
BEGIN
DBMS_OLAP.CREATE_ID(my_id);
DBMS_OLAP.VALIDATE_DIMENSION ('SALES_CHANNEL_DIM', 'COMMON', FALSE, TRUE,10);
END;



DECLARE
*
ERROR at line 1:
ORA-30475: feature not enabled: Java
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SUMMARY", line 39
ORA-06512: at "SYS.DBMS_SUMMARY", line 109
ORA-06512: at line 7

What is wrong with the sql?

Thanks.

Laura

 

[karluk]

It looks as if you haven't installed JVM in your database. You can probably fix this error by running initjvm.sql as sys. You can find the script in your {oracle_home}\javavm\install directory.

 

[dba123123]

Thanks. After I run the script, the error is gone.

Laura