0 Replies Latest reply on May 8, 2015 9:33 AM by jgcarrasco

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

    jgcarrasco

      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