Home » Developer & Programmer » Precompilers, OCI & OCCI » ORA-24333: zero iteration count Proc /Sun Unix
ORA-24333: zero iteration count Proc /Sun Unix [message #180721] Wed, 05 July 2006 00:14 Go to next message
mymot
Messages: 225
Registered: July 2005
Senior Member
HI,

my proc code execution is getting below error


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



what is the possible solutions, if the count = 0 , to handle count = 0 in Pro C code.

Thanks
Re: ORA-24333: zero iteration count Proc /Sun Unix [message #180726 is a reply to message #180721] Wed, 05 July 2006 00:54 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Please post the statement so we can look at it.

// *Action: Specify the number of times this statement must be executed
Re: ORA-24333: zero iteration count Proc /Sun Unix [message #180734 is a reply to message #180726] Wed, 05 July 2006 01:24 Go to previous message
mymot
Messages: 225
Registered: July 2005
Senior Member
Thanks Frank.


In order to avoid the error you should use "execute ( ) by oracle"
   instead:
 
    proc sql;
      connect to oracle (user=scott pw=tiger);
      execute (
        create table newemp as select * from emp
      ) by oracle;
      disconnect from oracle;
    quit;



Above sample code is provided for ORA-24333 by ORACLE user on google. But i am nt sure how i can get benefit of it.

Cheers

[Updated on: Wed, 05 July 2006 01:25]

Report message to a moderator

Previous Topic: SQL-02115: From Pro*C
Next Topic: ROWID Null Possible
Goto Forum:
  


Current Time: Fri Mar 29 09:40:19 CDT 2024