Turn off binding and run the application again to the point it fails.
On 30 Jul 2008 01:11:51 -0700, "forum.sybase.com"
<d.chambon@publiprint.fr> wrote:
>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_bruce.armstrong@teamsybase.com> a
>> 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.chambon@publiprint.fr> wrote in message
>> news:488f177d@forums-1-dub...
>>> killed = varchar2(1)
>>> formatpage_id = number(38)
>>> page_id = number(38)
>>>
>>> so the answer is no ;=)
>>>
>>>
>>> "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
>>> hq4u84tsr8kbar7ill6nv6ioj3bm97s3k9@4ax.com...
>>>>
>>>>
>>>> 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"
>>>> <d.chambon@publiprint.fr> wrote:
>>>>
>>>>>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_bruce.armstrong@teamsybase.com> a
>>>>>7hkr84907ktpp8c74gnu09q5j9ui409mam@4ax.com...
>>>>>>
>>>>>>
>>>>>> Are the values in any of the columns you are attempting to insert more
>>>>>> than 4000 characters long?
>>>>>>
>>>>>> On 27 Jul 2008 23:42:46 -0700, dchambon wrote:
>>>>>>
>>>>>>>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;
>>>>>>>
>>>>>>>> Version of Oracle?
>>>>>>>> Which driver?
>>>>>>>> What is involved in the insert statement?
>>>>>>>>
>>>>>>>> Otherwise, we're all just guesing.
>>>>>>>>
>>>>>>>> On 24 Jul 2008 23:35:40 -0700, dchambon wrote:
>>>>>>>>
>>>>>>>> >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
>>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>
>>
>
|