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
>>>>>>>
>>>>>
>>>>
>>>
>>
>>
>
>
|