error when compiling a stored procedure in oracle

Navigation
0

Dear good evening.

I request your help with the following script 

    CREATE OR REPLACE PACKAGE pkg_ingresar_cliente AS
    CURSOR cur_id_cli IS
            SELECT id_cliente FROM registro_cliente ORDER BY id_cliente DESC;
    PROCEDURE prc_ingreso_clientes (
    rut_cliente             IN registro_cliente.rut_cliente%TYPE,
    nombre_cliente          IN registro_cliente.nombre_cliente%TYPE,
    telefono_cliente        IN registro_cliente.telefono_cliente%TYPE,
    correo_cliente          IN registro_cliente.correo_cliente%TYPE,
    direccion_cliente       IN registro_cliente.direccion_cliente%TYPE,
    ifEmpresa               IN registro_cliente.ifEmpresa%TYPE,
    sexo_cliente            IN registro_cliente.sexo_cliente%TYPE,
    perfil_id_perfil        IN registro_cliente.perfil_id_perfil%TYPE,
    tarjeta_id_tarjeta      IN registro_cliente.tarjeta_id_tarjeta%TYPE,
    sucursal_id_sucursal    IN registro_cliente.sucursal_id_sucursal%TYPE);
    END pkg_ingresar_cliente;

    CREATE OR REPLACE PACKAGE BODY pkg_ingresar_cliente AS
    PROCEDURE prc_ingreso_clientes (
    rut_cliente             IN registro_cliente.rut_cliente%TYPE,
    nombre_cliente          IN registro_cliente.nombre_cliente%TYPE,
    telefono_cliente        IN registro_cliente.telefono_cliente%TYPE,
    correo_cliente          IN registro_cliente.correo_cliente%TYPE,
    direccion_cliente       IN registro_cliente.direccion_cliente%TYPE,
    ifEmpresa               IN registro_cliente.ifEmpresa%TYPE,
    sexo_cliente            IN registro_cliente.sexo_cliente%TYPE,
    perfil_id_perfil        IN registro_cliente.perfil_id_perfil%TYPE,
    tarjeta_id_tarjeta      IN registro_cliente.tarjeta_id_tarjeta%TYPE,
    sucursal_id_sucursal    IN registro_cliente.sucursal_id_sucursal%TYPE)
    IS
    BEGIN
    FOR i IN cur_id_cli
    LOOP
        INSERT INTO registro_cliente VALUES (id_cliente_seq.NEXTVAL,rut_cliente,nombre_cliente,telefono_cliente,
correo_cliente,direccion_cliente,ifEmpresa,
        sexo_cliente,perfil_id_perfil,tarjeta_id_tarjeta,sucursal_id_sucursal);
    END LOOP;
    END prc_ingreso_clientes;
    END pkg_ingresar_cliente;

When compiling, I get this error

  

Error (12,1): PLS-00103: Encountered the symbol "CREATE"

I still can not find a solution and I wanted to ask if anyone could help me to respond to this request.

from now on, I thank you for your help.

    
asked by Cesar Yevenes 09.05.2018 в 04:16
source

1 answer

0

In principle I should compile well, I do not see any error. Try putting a slash (/) after the two instructions 

END pkg_ingresar_cliente;
/
    
answered by 10.05.2018 в 10:09
Laravel Passport: invalid_credentials, The user credentials were incorrect Doubt to Close SQL Connection in NODE JS