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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
32 views