Data Mining - Error on inserting TREE_TERM_MINPCT_MODE value in settings table

SrikanthGH

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.

BCV

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

BCV

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