Oracle Attunity Connector Error: OCI Error Encounetered. ORA-24333: zero iteration count

• msbecca23

  SSC Veteran

  Points: 280

  More actions

  August 10, 2011 at 12:34 pm

  #255366

  Can someone help me figure out why I keep getting the following error message:

  Error at Data Flow Task [Oracle Source 13]: OCI Error Encounetered. ORA-24333: zero iteration count

  Using:

  Visual Studio 2008

  Microsoft Oracle Source Component by Attunity (v1.1)

  Oracle Source Editor: DataAccessMode = SQL Command

  I'm trying to send following command to open up a specific context:

  BEGIN

  EXECUTE IMMEDIATE 'begin pack_context.contextid_open(1);end';

  END;

  Even tried this SQL command as well, but still get same error:

  BEGIN

  pack_context.contextid_open(1);

  END;

  FYI...Both commands PARSE perfectly fine, but when hit OK button

  Researched ORA-24333: zero iteration count error and resolution says I must specific how many times I want the statement to execute...but it never tells me how/where to specific it.

  Ultimately what I'm trying to accomplish is to:

  1. Open specific context in one dataflow

  2. Then in next data flow, use that context to pull data

  from Oracle and perform some ETL operations on that data.

  Can't seem to put both sql commands into one dataflow...or maybe I just don't know how. If there is a better way for me to accomplish this, please by all means suggest one. I'm at my wits end!

  Thanks MsBecca