Forum Stats

  • 3,838,738 Users
  • 2,262,395 Discussions
  • 7,900,743 Comments

Discussions

ORA-06512: at "SYS.DBMS_PREDICTIVE_ANALYTICS", line 1254

jgcarrasco
jgcarrasco Member Posts: 2 Blue Ribbon
edited May 8, 2015 5:33AM in General Database Discussions

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

This discussion has been closed.