Forum Stats

  • 3,751,251 Users
  • 2,250,337 Discussions
  • 7,867,360 Comments

Discussions

Data Mining - Error on inserting TREE_TERM_MINPCT_MODE value in settings table

SrikanthGH
SrikanthGH Member Posts: 36
edited Jul 29, 2013 2:14AM in SQL & PL/SQL

Hi,

     In Data mining when I tried to create settings table and insert values into it. I am getting error on trying to insert TREE_TERM_MINPCT_MODE into the table.

The model that was being tried to create was Decision Tree.

BEGIN

   INSERT INTO DT_CA_SETTINGS_TEST (SETTING_NAME, SETTING_VALUE) VALUES

   (dbms_data_mining.TREE_TERM_MINPCT_MODE,to_char(1));

END;

Error report:

ORA-06550: line 3, column 22:

PLS-00302: component 'TREE_TERM_MINPCT_MODE' must be declared

ORA-06550: line 3, column 22:

PL/SQL: ORA-00984: column not allowed here

ORA-06550: line 2, column 4:

PL/SQL: SQL Statement ignored

06550. 00000 -  "line %s, column %s:\n%s"

*Cause:    Usually a PL/SQL compilation error.

*Action:

Thanks,
Srikanth.

Tagged:
SrikanthGH

Best Answer

  • BCV
    BCV Member Posts: 280
    Accepted Answer

    HI,

    BEGIN

       INSERT INTO DT_CA_SETTINGS_TEST (SETTING_NAME, SETTING_VALUE) VALUES

       (dbms_data_mining.TREE_TERM_MINPCT_NODE,to_char(1));

    END;

    That is not "Mode" its "NODE".

    Now Execute.

    Cheers..

    SrikanthGH

Answers

  • BCV
    BCV Member Posts: 280
    Accepted Answer

    HI,

    BEGIN

       INSERT INTO DT_CA_SETTINGS_TEST (SETTING_NAME, SETTING_VALUE) VALUES

       (dbms_data_mining.TREE_TERM_MINPCT_NODE,to_char(1));

    END;

    That is not "Mode" its "NODE".

    Now Execute.

    Cheers..

    SrikanthGH
This discussion has been closed.