ORA-01008: not all variables are limited

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
Post Reply
bride
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 98
Joined: Wed, 24 Sep 2008 11:00 pm
Location: Belo Horizonte - MG
Bride
OCA Oracle PL/SQL Developer Certified Associate

Someone can tell me in the literal what can be this error, in the insert

Select all

              ORA.Append("INSERT INTO WMS_ORDENTSAI (IDCORDENTSAI, IDCPRIATD, IDCTIPMDLTRP, IDCPSSCLIFOR, IDCPSSPRP,   "); 
                ORA.Append("	   					   IDCPSSTRP, IDCPSSTRPRDP, IDCPSSFLL, IDCSITORD, IDCSTE, IDCTIPORD, IDCLOT,   "); 
                ORA.Append("						   IDCPSSPNTDST, NROORD, DATGER, DESOBS, DATPGR,  NUMAGP,   "); 
                ORA.Append("						   NUMTIPORD, BOLDTFMRC, BOLATDPRC, BOLRECMERFORPED, BOLCANORDATDPRC, "); 
                ORA.Append("						   IDCUSR, VALQTDVOL, VLRCIF, VLRMTRCUB, VLRMTRQUA, IDCDOC, CODAGPMTG, GERAUTOPE, BOLCANLOT,NUMSEQCRG, BOLPERPENESQ, VLRPERATNORDCMP)  "); 
                ORA.Append("				    VALUES (S_WMS_ORDENTSAI.NEXTVAL, @IDCPRIATD, @IDCTIPMDLTRP, @IDCPSSCLIFOR, @IDCPSSPRP,   "); 
                ORA.Append("	   					   @IDCPSSTRP, @IDCPSSTRPRDP, @IDCPSSFLL, @IDCSITORD, @IDCSTE, @IDCTIPORD, @IDCLOT,   "); 
                ORA.Append("						   @IDCPSSPNTDST, @NROORD, @DATGER, @DESOBS, @DATPGR, @DATATD, @NUMAGP,  "); 
                ORA.Append("						   @NUMTIPORD, @BOLDTFMRC, @BOLATDPRC, @BOLRECMERFORPED, @BOLCANORDATDPRC,  "); 
                ORA.Append("						   @IDCUSR, @VALQTDVOL, @VLRCIF, @VLRMTRCUB, @VLRMTRQUA, @IDCDOC, @CODAGPMTG, @GERAUTOPE, @BOLCANLOT,@NUMSEQCRG, @BOLPERPENESQ,NVL(@VLRPERATNORDCMP,0)) "); 
 
                Array Comandos = Data.CreateCmdParameters( 
                    new StcCmdParameter(ORA.ToString(), (int)ClsBco.Ora), 
                    new StcCmdParameter(SQL.ToString(), (int)ClsBco.Sql)); 
 
                Array Parametros = Data.CreatePrmParameters( 
                new StcPrmParameter("IDCPRIATD", row["IDCPRIATD"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCTIPMDLTRP", row["IDCTIPMDLTRP"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCPSSCLIFOR", row["IDCPSSCLIFOR"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCPSSPRP", row["IDCPSSPRP"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCPSSTRP", row["IDCPSSTRP"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCPSSTRPRDP", row["IDCPSSTRPRDP"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCPSSFLL", row["IDCPSSFLL"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCSITORD", row["IDCSITORD"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCSTE", row["IDCSTE"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCTIPORD", row["IDCTIPORD"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCLOT", row["IDCLOT"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCPSSPNTDST", row["IDCPNTDST"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("NROORD", row["NroOrd"], (int)TipDdo.Vch, (int)PrmDrn.Inp), 
                new StcPrmParameter("DATGER", row["DatGer"], (int)TipDdo.DatHra, (int)PrmDrn.Inp), 
                new StcPrmParameter("DESOBS", row["DESOBS"], (int)TipDdo.Vch, (int)PrmDrn.Inp), 
                new StcPrmParameter("DATPGR", row["DatPgr"], (int)TipDdo.DatHra, (int)PrmDrn.Inp), 
                new StcPrmParameter("NUMAGP", row["NUMAGP"], (int)TipDdo.Vch, (int)PrmDrn.Inp), 
                new StcPrmParameter("NUMTIPORD", row["NUMTIPORD"], (int)TipDdo.Vch, (int)PrmDrn.Inp), 
                new StcPrmParameter("BOLDTFMRC", row["BOLDTFMRC"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("BOLATDPRC", row["BOLATDPRC"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("VALQTDVOL", row["VALQTDVOL"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("BOLRECMERFORPED", row["BOLRECMERFORPED"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("BOLCANORDATDPRC", row["BOLCANORDATDPRC"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCUSR", row["IDCUSR"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("VLRCIF", row["VLRCIF"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("VLRMTRCUB", row["VLRMTRCUB"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("VLRMTRQUA", row["VLRMTRQUA"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("IDCDOC", row["IDCDOC"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("CODAGPMTG", row["CODAGPMTG"], (int)TipDdo.Vch, (int)PrmDrn.Inp), 
                new StcPrmParameter("GERAUTOPE", row["GERAUTOPE"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("BOLCANLOT", row["BOLCANLOT"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("NUMSEQCRG", row["NUMSEQCRG"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("BOLPERPENESQ", row["BOLPERPENESQ"], (int)TipDdo.Num, (int)PrmDrn.Inp), 
                new StcPrmParameter("VLRPERATNORDCMP", row["VLRPERATNORDCMP"], (int)TipDdo.Num, (int)PrmDrn.Inp) 
                ); 
                lngIdcOrdEntSai = new AcsDdo(TipBco.Prd).ExecuteCmdReturnKey(Comandos, Parametros);
rogenaro
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Fri, 30 Mar 2007 7:26 pm
Location: Londrina - PR
Rafael O. Genaro

The error ORA-01008 occurs when any of the parameters was not informed.
In case, your insert uses 35 parameters, but you have only defined 34 of them.
bride
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 98
Joined: Wed, 24 Sep 2008 11:00 pm
Location: Belo Horizonte - MG
Bride
OCA Oracle PL/SQL Developer Certified Associate

Thanks this field here @datatd that was for more
douglas.gelsleichter
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Wed, 24 Apr 2013 4:58 pm

Thank you, also helped me.
headtechdev
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Tue, 17 Aug 2021 11:52 am
Location: Jundiaí

I have the same problem in the script below, please help me identify the error.

Select all

 
DECLARE V_CODCID INT(30); 
        V_CODUF INT(30);  
        V_NOMECID VARCHAR2(60); 
    BEGIN 
      FOR X IN (SELECT DISTINCT * FROM TEMP_PARCEIRO ORDER BY 1) 
      LOOP 
           V_NOMECID := X.CODCID; 
           BEGIN 
             SELECT NVL(MIN(CID.CODCID),0), UFS.CODUF 
             INTO   :V_CODCID,  :V_CODUF 
             FROM   TSICID CID, TSIUFS UFS 
             WHERE  CID.UF = UFS.CODUF 
               AND   
               (TRIM(UPPER(translate( V_NOMECID, 
                    'ÁÇÉÍÓÚÀÈÌÒÙÂÊÎÔÛÃÕËÜáçéíóúàèìòùâêîôûãõëü', 
                    'ACEIOUAEIOUAEIOUAOEUaceiouaeiouaeiouaoeu'))) =  
                     
                    TRIM(UPPER(translate( CID.NOMECID, 
                    'ÁÇÉÍÓÚÀÈÌÒÙÂÊÎÔÛÃÕËÜáçéíóúàèìòùâêîôûãõëü', 
                    'ACEIOUAEIOUAEIOUAOEUaceiouaeiouaeiouaoeu')))) 
             GROUP BY UFS.CODUF; 
           EXCEPTION WHEN NO_DATA_FOUND THEN 
              V_CODCID := 0; 
              V_CODUF  := 0; 
           END; 
                        
           IF V_CODCID = 0 THEN 
               
              SELECT MAX(NVL(TSICID.CODCID,0)) + 1  
                INTO :V_CODCID 
                FROM TSICID; 
                 
              INSERT INTO TSICID ( CODCID, UF, NOMECID, DTALTER ) 
                          VALUES ( V_CODCID, V_CODUF, V_NOMECID, SYSDATE); 
           END IF; 
            
           UPDATE TEMP_PARCEIRO PARC SET PARC.CODCID = V_CODCID WHERE PARC.CODPARC = X.CODPARC; 
      END LOOP; 
    END; 
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

You have created a new topic for this question: https://en.glufke.net/oracle/viewtopic.php?f=2&t=11037 answered at this link above.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest