0 Replies Latest reply on Dec 6, 2002 1:06 PM by 206930

    ORA-24333 An iteration count of zero was specified for the statement

    206930
      Hi all,
      in example below oracle generate error ORA-24333,
      Cause: An iteration count of zero was specified for the statement
      Action: Specify the number of times this statement must be executed

      On Error GoTo errHandler:
      Dim pOraStmt As OraSqlStmt 'obiekt OO4O
      Dim stat As Long

      aWystapilBlad = False
      gOraDatabase.LastServerErrReset
      gOraDatabase.BeginTrans
      Set pOraStmt = gOraDatabase.CreateSql("begin " & _
      NAZWA_PAKIETU & "." & NAZWA_PROCEDURY & _
      "; END;", ORASQL_NONBLK)
      stat = pOraStmt.NonBlockingState

      While stat = ORASQL_STILL_EXECUTING
      DoEvents
      stat = pOraStmt.NonBlockingState
      Wend

      '>>>>>>>>>>>>>>>>>ERROR ORA-24333 zero iteration count!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1

      If gOraDatabase.LastServerErr > 0 Then
      aWystapilBlad = True
      GenerujKomunikaty BLAD_SYSTEMOWY_NR & Err.Number & vbNewLine & BLAD_OPIS_BLEDU & gOraDatabase.LastServerErrText, WyswietlNaEkran, blad, TYTUL_APLIKACJA
      PrzeniesDanychCODGiK = False
      End If
      gOraDatabase.CommitTrans
      PrzeniesDanych = True
      Exit Function
      errHandler:
      aWystapilBlad = True
      gOraDatabase.Rollback
      PrzeniesDanych = False

      Can anybody help me?

      Regards
      Zbyszek