Skip to Main Content

Data Science & Machine Learning

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!

error on running Create Model

hello there,

I'm trying to create a model with this, in sql from the worsheet of ADB in OCI

BEGIN

DBMS\_DATA\_MINING.CREATE\_MODEL(

    model\_name          => 'FRAUDE\_DETECCION\_MODEL',  -- Nombre del modelo

    mining\_function     => DBMS\_DATA\_MINING.CLASSIFICATION,  -- Tipo de ML (Clasificación)

    data\_table\_name     => 'TRANSACCIONES\_TEST',  -- Nombre de la tabla de entrenamiento

    case\_id\_column\_name => 'ID\_TRANSACCION',  -- ID único de cada fila

    target\_column\_name  => 'ES\_FRAUDE',  -- Variable objetivo (0 o 1)

    settings\_table\_name => NULL  -- Configuración predeterminada

);

END;

/

But when i do enter, i received this errors

ORA-40104: invalid training data for model build ORA-06512: at "SYS.DBMS_DATA_MINING", line 355 ORA-06512: at "SYS.DBMS_DATA_MINING", line 603 ORA-06512: at "SYS.DBMS_DATA_MINING", line 563 ORA-06512: at line 2 and i don't know if it is for lack of priviliges o there is something missing in the creation.

thank

Comments
Post Details
Added on Mar 6 2025
0 comments
106 views