Não Consigo Compilar Package

[Rafael Mitsunaka 11]

Pessoal,

 

Não conheço muito oracle e estou com 1 problema.

 

Estou tentando alterar um Package que possui algumas procedures.

 

Ao compilar me gera o seguinte erro:

[Error] PLS-00382 (7: 15): PLS-00382: expression is of wrong type

 

o que eu fiz foi adicionar 2 campos a mais no retorno do meu select.(PacoteAcordo.ID_AGREEMENT,PacoteAcordo.DT_SYSTEM )

 

SELECT 
                   PacoteAcordo.ID_PACKAGE_AGREEMENT  ,
                   Pacote.NM_PACKAGE  ,                    
                   PacoteAcordo.NM_FANCY_NAME,  
                   PacoteAcordo.DT_START_TERM , 
                   PacoteAcordo.DT_END_TERM  ,
                   Segmento.DE_SEGMENT  ,
                   TipoPacote.DE_PACKAGE_TYPE,  
                   PacoteAcordo.ID_PACKAGE ,                    
                   NVL(AnexoPacote.ID_PACKAGE_ATTACHMENT, 0) AS ID_PACKAGE_ATTACHMENT ,
                   PacoteAcordo.ID_AGREEMENT , 
                   PacoteAcordo.DT_SYSTEM                   


               FROM PRD.TBD_PRD_PACKAGE Pacote
               INNER JOIN AGR.TBD_AGR_PACKAGE_AGREEMENT PacoteAcordo ON Pacote.ID_PACKAGE = PacoteAcordo.ID_PACKAGE
               INNER JOIN PRD.TBD_PRD_PACKAGE_TYPE TipoPacote ON Pacote.ID_PACKAGE_TYPE = TipoPacote.ID_PACKAGE_TYPE
               LEFT JOIN AGR.TBR_AGR_PACKAGE_ATTACHMENT AnexoPacote ON (AnexoPacote.ID_PACKAGE_AGREEMENT = PacoteAcordo.ID_PACKAGE_AGREEMENT)
               LEFT OUTER JOIN PAR.TBA_PAR_SEGMENT_INSURANCE Segmento ON Pacote.ID_SEGMENT_INSURANCE = Segmento.ID_SEGMENT_INSURANCE
               WHERE (PacoteAcordo.ID_AGREEMENT =  nvl(P_IDPACKAGEAGREEMENT,PacoteAcordo.ID_PACKAGE_AGREEMENT)); 

 

 

o que pode ser esse erro?

[Motta 645]

Qual o TYPE de AnexoPacote.ID_PACKAGE_ATTACHMENT, NUMBER ?

[Rafael Mitsunaka 11]

é NUMBER (18)

[Motta 645]

Tem o Package e o Package Body, alterou ambos ?

 

PacoteAcordo.ID_AGREEMENT , P_IDPACKAGEAGREEMENT e PacoteAcordo.ID_PACKAGE_AGREEMENT tem o mesmo TYPE ?