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
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