I can not create a package

Question

I can not create a package

Navigation

#1 by (0 votes)

1

I try to create a PL / SQL package in Oracle with the header

create  PACKAGE "PO_LDS_CLI_AFECTADO2"  AS
PROCEDURE GET_VIP(V_ORDER in number, v_out OUT NUMBER);
END po_lds_cli_afectado2;

and the body

create or replace PACKAGE BODY           "PO_LDS_CLI_AFECTADO2"     AS
PROCEDURE GET_VIP(v_order IN NUMBER, v_out OUT NUMBER)
IS
v_rpta  INTEGER;
BEGIN
    v_rpta := PO_LDS_SYNCIFX.GET_CLIENTE_IMPORTANTE_AFEC(v_order);   
  v_out := v_rpta;      
END GET_VIP
END po_lds_cli_afectado2

drop package po_lds_cli_afectado2

But I get the following error:

pls-00103 Encountered the symbol "end-of-file" when excepting one of the following: ;

oracle

asked by CESAR NICOLINI RIVER 21.03.2017 в 15:45

source

1 answer

Problems with http://schemas.android.com/apk/res/android Is it possible to create an html.exe app? [closed]

score 0 · Accepted Answer

You are missing several; in your code (in the body):

    create or replace PACKAGE BODY           "PO_LDS_CLI_AFECTADO2"     AS
        PROCEDURE GET_VIP(v_order IN NUMBER, v_out OUT NUMBER) IS
            v_rpta  INTEGER;
        BEGIN
            v_rpta := PO_LDS_SYNCIFX.GET_CLIENTE_IMPORTANTE_AFEC(v_order);   
            v_out := v_rpta;      
        END GET_VIP;
   END po_lds_cli_afectado2;