Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-24333: zero iteration count

prajithparanMar 4 2011 — edited Mar 24 2011
Hi Experts,

Env :
Oracle 11g R1
Sparc10
OCI (Sun studio)

The above error is ccoming when 'SELECT' statement is executed as dynamic SQL . If the SQL is static (table name is hard coded) it is working fine.

SQL= ' SELECT * from EMP' is working
the same replace with SQL= 'SELECT * FROM %s' , table_name' the above error is thrown.


Any Idea what could be the reason for this.?

Please note that this SQL is executed multiple times very frequently

Thanks in advance
Prajith
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2011
Added on Mar 4 2011
#oracle-call-interface-oci
1 comment
2,132 views