Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Mining - Error on inserting TREE_TERM_MINPCT_MODE value in settings table

SrikanthGHJul 29 2013 — edited Jul 29 2013

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.

This post has been answered by BCV on Jul 29 2013
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 26 2013
Added on Jul 29 2013
1 comment
304 views