Hi,
The call fails but the error message is not explanatory. Any clue?
SQL>
DECLARE
2 p_accuracy NUMBER(10,9);
3 BEGIN
4 DBMS_PREDICTIVE_ANALYTICS.PREDICT(
5 accuracy => P_ACCURACY,
6 data_table_name =>'MINING_DATA_APPLY_V',
7 case_id_column_name =>'CUST_ID',
8 target_column_name =>'AFFINITY_CARD',
9 result_table_name =>'P_RESULT_TBL');
10 DBMS_OUTPUT.PUT_LINE('Accuracy: ' || p_accuracy);
11 END;
12 /
p_accuracy NUMBER(10,9);
*
ERROR at line 2:
ORA-06512: at "SYS.DBMS_PREDICTIVE_ANALYTICS", line 1254
ORA-06512: at line 4
This code is an example from:
http://docs.oracle.com/cd/B28359_01/datamine.111/b28129/pa_dmcon.htm#CACFBEHC
Info that can help:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
@ddl MINING_DATA_APPLY_V
PL/SQL procedure successfully completed.
DDL
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CREATE OR REPLACE FORCE EDITIONABLE VIEW DM.MINING_DATA_APPLY_V (CUST_ID, CUST_GENDER, AGE, CUST_MARITAL_STATUS, COUNTRY_NAME, CUST_INCOME_LEVEL, EDUCATION, OCCUPATION, HOUSEHOLD_SIZE, YRS_RESIDENCE, AFFINITY_CARD, BULK_PACK_DISKETTES, FLAT_PANEL_MONITOR, HOME_THEATER_PACKAGE,
SELECT
a.CUST_ID,
a.CUST_GENDER,
2003-a.CUST_YEAR_OF_BIRTH AGE,
a.CUST_MARITAL_STATUS,
c.COUNTRY_NAME,
a.CUST_INCOME_LEVEL,
b.EDUCATION,
b.OCCUPATION,
b.HOUSEHOLD_SIZE,
b.YRS_RESIDENCE,
b.AFFINITY_CARD,
b.BULK_PACK_DISKETTES,
b.FLAT_PANEL_MONITOR,
b.HOME_THEATER_PACKAGE,
b.BOOKKEEPING_APPLICATION,
b.PRINTER_SUPPLIES,
b.Y_BOX_GAMES,
b.OS_DOC_SET_KANJI
FROM
sh.customers a,
sh.supplementary_demographics b,
sh.countries c
WHERE
a.CUST_ID = b.CUST_ID
AND a.country_id = c.country_id
AND a.cust_id between 100001 and 101500;
1 row selected.
SQL>
select * from session_roles;
ROLE
--------------------------------------------------------------------------------------------------------------------------------
CONNECT
DBA
SELECT_CATALOG_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
CAPTURE_ADMIN
EXP_FULL_DATABASE
IMP_FULL_DATABASE
DATAPUMP_EXP_FULL_DATABASE
DATAPUMP_IMP_FULL_DATABASE
XS_RESOURCE
GATHER_SYSTEM_STATISTICS
OPTIMIZER_PROCESSING_RATE
EM_EXPRESS_BASIC
EM_EXPRESS_ALL
SCHEDULER_ADMIN
HS_ADMIN_SELECT_ROLE
HS_ADMIN_EXECUTE_ROLE
XDBADMIN
XDB_SET_INVOKER
WM_ADMIN_ROLE
JAVA_ADMIN
JAVA_DEPLOY
CTXAPP
OLAP_XS_ADMIN
OLAP_DBA
ODMRUSER
27 rows selected.
Mensaje editado por: jgcarrasco