Tentei criar essa pacakge com uma proc dentro e me dá vários erros.
Selecionar tudo
---------------------Header da Package-----------------------------
CREATE OR REPLACE PACKAGE PKG_CARTA_QUITACAO_HEADER
IS
BEGIN
SP_CARTA_QUITACAO_HEADER(
P_NR_REGISTRO IN CARTA_QUITACAO_HEADER.NR_REGISTRO%TYPE,
P_NR_SEQUENCIA_REGISTRO IN CARTA_QUITACAO_HEADER.NR_SEQUENCIA_REGISTRO%TYPE,
P_DT_PROCESSAMENTO IN CARTA_QUITACAO_HEADER.DT_PROCESSAMENTO%TYPE,
P_NR_SEQUENCIA_ARQUIVO IN CARTA_QUITACAO_HEADER.NR_SEQUENCIA_ARQUIVO%TYPE,
P_CD_PROGRAMA IN CARTA_QUITACAO_HEADER.CD_PROGRAMA%TYPE,
P_CD_EMPRESA IN CARTA_QUITACAO_HEADER.CD_EMPRESA%TYPE,
P_NR_ANO_QUITACAO IN CARTA_QUITACAO_HEADER.NR_ANO_QUITACAO%TYPE,
P_FL_PROCESSADO IN CARTA_QUITACAO_HEADER.FL_PROCESSADO%TYPE
);
SP_CARTA_QUITACAO_HEADER_UPDATE(
P_FL_PROCESSADO
);
END PKG_CARTA_QUITACAO_HEADER;
/
-----------------------Body da Package----------------------------
CREATE OR REPLACE PACKAGE BODY PKG_CARTA_QUITACAO_HEADER
IS
BEGIN
PROCEDURE SP_CARTA_QUITACAO_HEADER(
P_NR_REGISTRO CARTA_QUITACAO_HEADER.NR_REGISTRO%TYPE,
P_NR_SEQUENCIA_REGISTRO CARTA_QUITACAO_HEADER.NR_SEQUENCIA_REGISTRO%TYPE,
P_DT_PROCESSAMENTO CARTA_QUITACAO_HEADER.DT_PROCESSAMENTO%TYPE,
P_NR_SEQUENCIA_ARQUIVO CARTA_QUITACAO_HEADER.NR_SEQUENCIA_ARQUIVO%TYPE,
P_CD_PROGRAMA CARTA_QUITACAO_HEADER.CD_PROGRAMA%TYPE,
P_CD_EMPRESA CARTA_QUITACAO_HEADER.CD_EMPRESA%TYPE,
P_NR_ANO_QUITACAO CARTA_QUITACAO_HEADER.NR_ANO_QUITACAO%TYPE,
P_FL_PROCESSADO CARTA_QUITACAO_HEADER.FL_PROCESSADO%TYPE
)
AS
V_INSERT BOOLEAN;
BEGIN
V_INSERT := TRUE;
BEGIN
INSERT INTO CARTA_QUITACAO_HEADER(
ID_CARTA_QUITACAO_HEADER,
NR_REGISTRO,
NR_SEQUENCIA_REGISTRO,
DT_PROCESSAMENTO,
NR_SEQUENCIA_ARQUIVO,
CD_PROGRAMA,
CD_EMPRESA,
NR_ANO_QUITACAO,
FL_PROCESSADO
VALUES(
SEQ_CARTA_QUITACAO_HEADER.NEXTVAL,
P_NR_REGISTRO,
P_NR_SEQUENCIA_REGISTROISTRO,
P_DT_PROCESSAMENTO,
P_NR_SEQUENCIA_ARQUIVO UIVO,
P_CD_PROGRAMA,
P_CD_EMPRESA,
P_NR_ANO_QUITACAO,
P_FL_PROCESSADO);
EXCEPTION
WHEN OTHERS
V_INSERT := FALSE;
END;
IF V_INSERT THEN
COMMIT;
ELSE
ROLLBACK;
END IF;
END SP_CARTA_QUITACAO_HEADER;
SP_CARTA_QUITACAO_HEADER_UPDATE(P_FL_PROCESSADO)
AS
BEGIN
END SP_CARTA_QUITACAO_HEADER_UPDATE;
END PKG_CARTA_QUITACAO_HEADER;
/
Esses são os erros que pego no OutPut
3/1 PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following: end function pragma procedure subtype type <an identifier> <a double-quoted delimited-identifier> current cursor delete exists prior
5/33 PLS-00103: Encountered the symbol "CARTA_QUITACAO_HEADER" when expecting one of the following: ( The symbol "(" was substituted for "CARTA_QUITACAO_HEADER" to continue.
6/30 PLS-00103: Encountered the symbol "CARTA_QUITACAO_HEADER" when expecting one of the following: ( The symbol "(" was substituted for "CARTA_QUITACAO_HEADER" to continue.
7/30 PLS-00103: Encountered the symbol "CARTA_QUITACAO_HEADER" when expecting one of the following: ( The symbol "(" was substituted for "CARTA_QUITACAO_HEADER" to continue.
8/30 PLS-00103: Encountered the symbol "CARTA_QUITACAO_HEADER" when expecting one of the following: ( The symbol "(" was substituted for "CARTA_QUITACAO_HEADER" to continue.
9/30 PLS-00103: Encountered the symbol "CARTA_QUITACAO_HEADER" when expecting one of the following: ( The symbol "(" was substituted for "CARTA_QUITACAO_HEADER" to continue.
10/30 PLS-00103: Encountered the symbol "CARTA_QUITACAO_HEADER" when expecting one of the following: ( The symbol "(" was substituted for "CARTA_QUITACAO_HEADER" to continue.
11/30 PLS-00103: Encountered the symbol "CARTA_QUITACAO_HEADER" when expecting one of the following: ( The symbol "(" was substituted for "CARTA_QUITACAO_HEADER" to continue.
12/30 PLS-00103: Encountered the symbol "CARTA_QUITACAO_HEADER" when expecting one of the following: ( The symbol "(" was substituted for "CARTA_QUITACAO_HEADER" to continue.
13/3 PLS-00103: Encountered the symbol ";" when expecting one of the following: ) , and or
20/0 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: end not pragma final instantiable persistable order overriding static member constructor map
Errors: check compiler log
Essa tabela já está criada
CARTA_QUITACAO_HEADER