PB11 - ORA-24333: zero iteration count

[dchambon]

I'm doing an INSERT ... USING SQLCA and get an "ORA-24333:
zero iteration count" error

same thing for UPDATE or DELETE (all sql statement that
writes data) but SELECT works :-(

is there a problem in the database profile ??
The SQLCA declaration was paste from PB9. Hope that can
help

[dchambon]

If I ignore the compilation message, the insert works !!!

Seems like a bug ???

[Bruce Armstrong [TeamSybase]]

Version of Oracle?
Which driver?
What is involved in the insert statement?

Otherwise, we're all just guesing.

[dchambon]

Hope that's what you were expecting :

// Profile PROD
SQLCA.DBMS = "O84 Oracle8/8i (8.x.4+)"
SQLCA.LogPass = <*****>
SQLCA.ServerName = "PROD"
SQLCA.LogId = "devpb"
SQLCA.AutoCommit = False
SQLCA.DBParm = "DisableUnicode=1"

-> Oracle 8.1.6

INSERT INTO xtads_formatpage ( killed,
format_id,
page_id,
)
VALUES (:w2_killed,
:formatpage_id,
:page_id,
)
USING SQLCA;

[Bruce Armstrong [TeamSybase]]

Are the values in any of the columns you are attempting to insert more
than 4000 characters long?

[Didier CHAMBON]

hi,

hope that's what you were excepting for :

// Profile PROD

SQLCA.DBMS = "O84 Oracle8/8i (8.x.4+)"

SQLCA.LogPass = <*****>

SQLCA.ServerName = "PROD"

SQLCA.LogId = "devpb"

SQLCA.AutoCommit = False

SQLCA.DBParm = "DisableUnicode=1"

INSERT INTO xtads_formatpage ( killed,

format_id,

page_id

)

VALUES (:w2_killed,

:formatpage_id,

:page_id

)

USING SQLCA;

Regards,

Didier.

"Bruce Armstrong [TeamSybase]" <NOCANSPAM_br...@teamsybase.com> a
écrit dans le message de news: 7hkr84907ktpp8c74...@4ax.com...

[Bruce Armstrong [TeamSybase]]

Are the values in any of the columns you are attempting to insert more
than 4000 characters long?

On 28 Jul 2008 23:19:34 -0700, "Didier CHAMBON"

[forum.sybase.com]

killed = varchar2(1)
formatpage_id = number(38)
page_id = number(38)

so the answer is no ;=)

"Bruce Armstrong [TeamSybase]" <NOCANSPAM_br...@teamsybase.com> a

écrit dans le message de news: hq4u84tsr8kbar7il...@4ax.com...

[Bruce Armstrong [TeamSybase]]

It looks like you're giving me the table definition. What I was
specifically asking about is the size of the data involved in the binding
(:w2_killed, :formatpage_id,:page_id). If you attempt to pass back more
data in a bind variable than PB bound the variable to because of the
underlying table defnition, you can get a 24333 error.

"forum.sybase.com" <d.ch...@publiprint.fr> wrote in message
news:488f177d@forums-1-dub...

[forum.sybase.com]

I'm afraid I don't understand what you're talking about :=( (not the table
definition sentence, the next one)

How can I get the size of the data ?

Didier.

"Bruce Armstrong [TeamSybase]" <NOCANSPAM_br...@teamsybase.com> a

écrit dans le message de news: 488f36cb@forums-1-dub...

[Bruce Armstrong [TeamSybase]]

Turn off binding and run the application again to the point it fails.

On 30 Jul 2008 01:11:51 -0700, "forum.sybase.com"

[forum.sybase.com]

Bruce,

sorry again but I don't know how to turn off binding. I've been using
PowerBuilder since 1 month so you can see I'm a newbie ;=) Is this a SQLCA
parameter ??

second thing, the error only appears when compiling not when the app is ran.

Didier.

"Bruce Armstrong [TeamSybase]" <NOCANSPAM_br...@teamsybase.com> a

écrit dans le message de news: m3p0941oaks8negtd...@4ax.com...

[Bruce Armstrong [TeamSybase]]

In the IDE, look for the "Disable Bind" option on the Transaction tab for
the connection. In code, you would add DisableBind=1 to the DBParm
parameter.

The fact that it only happens when you compile was a rather important piece
of info. In that case, add this to the PB.INI file in the [PB] section:

dbsign=0

That will turn off the feature that attempts to validate SQL at compile
time.

You mgiht also try stripping out the "USING SQLCA" clause. That's the
default, so it's meaningless to add it, but it may be fooling the compiler
into doing something stupid.

"forum.sybase.com" <d.ch...@publiprint.fr> wrote in message

news:48906f3e$1@forums-1-dub...