Error call UPDATEBLOB - PowerBuilder 10.5.1 (6627) and ASA 9.02 (3480)

Hello

i have following error on UPDATEBLOB  - "Bind parameter value for '?' is 
too big (778659)"

have anyone a clue for my problem - i don't know what i should do!
thank's
Michael
0
M
12/16/2007 7:37:05 PM
sybase.powerbuilder.general 62418 articles. 17 followers. Follow

7 Replies
661 Views

Similar Articles

[PageSpeed] 45

What DBMS are you using??

"M.Erlinger" <mierli@noemail.noemail> wrote in message 
news:47657e61@forums-1-dub...
> Hello
>
> i have following error on UPDATEBLOB  - "Bind parameter value for '?' is 
> too big (778659)"
>
> have anyone a clue for my problem - i don't know what i should do!
> thank's
> Michael 


0
Roland
12/17/2007 1:09:23 PM
Michael;

To add to Roland's question ...

1) What is the Blob Data Type?
2) What DB connection mechanism are you  using?

-- 
Regards ... Chris
http://chrispollach.pbdjmagazine.com
 ,\|/,
(0 0)
-(_)-


"M.Erlinger" <mierli@noemail.noemail> wrote in message 
news:47657e61@forums-1-dub...
> Hello
>
> i have following error on UPDATEBLOB  - "Bind parameter value for '?' is 
> too big (778659)"
>
> have anyone a clue for my problem - i don't know what i should do!
> thank's
> Michael 


0
Chris
12/17/2007 2:23:34 PM
Hello

ad 1) long binary object
ad 2) odbc to adaptive sql anywhere 9.02

thank's for help
Michael

Chris Pollach schrieb:
> Michael;
> 
> To add to Roland's question ...
> 
> 1) What is the Blob Data Type?
> 2) What DB connection mechanism are you  using?
> 
0
M
12/17/2007 7:19:36 PM
Hello,

Maybe there is a limit on the length of a parameter in ODBC, even for  
blobs?

We had found some time ago that ODBC (not the database specific driver,  
but the MS ODBC32.DLL, as far as I understand) just cuts off SQL  
statements at 32k. I did not so far find any document stating this limit,  
but it definitely exists.

Frank

On Mon, 17 Dec 2007 20:19:36 +0100, M.Erlinger <mierli@noemail.noemail>  
wrote:

> Hello
>
> ad 1) long binary object
> ad 2) odbc to adaptive sql anywhere 9.02
>
> thank's for help
> Michael
>
> Chris Pollach schrieb:
>> Michael;
>>  To add to Roland's question ...
>>  1) What is the Blob Data Type?
>> 2) What DB connection mechanism are you  using?
>>

0
Frank
12/17/2007 8:14:16 PM
Michael;

Wow ... this is weird - I have never had a problem with SA 9 or 10 and 
blobs!

1)    Did you set the SQLCA.AutoCommit = TRUE?
2)    PB 10.x is Unicode and ASA9 is ANSI - did you  load your Blob variable 
using the .... Blob (yourVar, EncodingANSI!)?

-- 
Regards ... Chris
http://chrispollach.pbdjmagazine.com
 ,\|/,
(0 0)
-(_)-


"M.Erlinger" <mierli@noemail.noemail> wrote in message 
news:4766cbc8$1@forums-1-dub...
> Hello
>
> ad 1) long binary object
> ad 2) odbc to adaptive sql anywhere 9.02
>
> thank's for help
> Michael
>
> Chris Pollach schrieb:
>> Michael;
>>
>> To add to Roland's question ...
>>
>> 1) What is the Blob Data Type?
>> 2) What DB connection mechanism are you  using?
>> 


0
Chris
12/18/2007 12:22:59 PM
hello

thank's for your help.
the problem was: during the INSERT-statement, the blob-varialbe was not 
null; now i set i to null, and fill it after the INSERT-statement, and 
do next the UPDATEBLOB-statement.
now it works fine......

regards
Michael
0
M
12/20/2007 9:02:12 AM
        Ahhh yes ... you cannot process the Blob data until the new row is 
added as a regular Insert DML statement does not support the binary data 
stream of your Blob.

 Excellent news - good catch!        :-)


"M.Erlinger" <mierli@noemail.noemail> wrote in message 
news:476a2f94$1@forums-1-dub...
> hello
>
> thank's for your help.
> the problem was: during the INSERT-statement, the blob-varialbe was not 
> null; now i set i to null, and fill it after the INSERT-statement, and do 
> next the UPDATEBLOB-statement.
> now it works fine......
>
> regards
> Michael 


0
Chris
12/20/2007 1:06:37 PM
Reply:

Similar Artilces:

Smoke [5.10.1] perl-5.10.1-1-gca8de22 FAIL(F) MSWin32 WinXP/.Net SP3 (x86/2 cpu) #9
Automated smoke report for 5.10.1 patch ca8de220718ba91d5a5fdd9779497cd5b02= 50258 perl-5.10.1-1-gca8de22 maldoror.bath.planit.group: Intel(R) Core(TM)2 CPU 6700 @ 2.66GHz(~2659 MHz= ) (x86/2 cpu) on MSWin32 - WinXP/.Net SP3 using cl version 13.10.3077 smoketime 4 hours 45 minutes (average 28 minutes 32 seconds) Summary: FAIL(F) O =3D OK F =3D Failure(s), extended report at the bottom X =3D Failure(s) under TEST but not under harness ? =3D still running or test results not (yet) available Build failures during: - =3D unknown or N/A c =3D Configure,...

error starting fox: 1.9.1.5 xulrunner version needs to be upgraded to 1.9.1.7.
Name: Product: Firefox Summary: error starting fox: 1.9.1.5 xulrunner version needs to be upgraded to 1.9.1.7. Comments: my firefox was automagically updated a few days ago, and now when i triy to start it, even in safe mode, i get an error that more or less says 1.9.1.5 xulrunner version needs to be upgraded to 1.9.1.7. OS is win 7 Browser Details: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0) From URL: ...

Smoke [5.10.1] perl-5.10.1-RC1-1-gbadf489 FAIL(F) netbsd 5.0.1 (i386/1 cpu)
Automated smoke report for 5.10.1 patch badf48949ef0f6be41c06a682330f4aa37c4f4ff perl-5.10.1-RC1-1-gbadf489 p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.1 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 9 hours 14 minutes (average 1 hour 9 minutes) Summary: FAIL(F) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = ...

Smoke [5.8.9] maint-5.8-10-g5d97567 FAIL(m) freebsd 9.1-RELEASE (i386/1 cpu)
Automated smoke report for 5.8.9 patch 5d97567dd5d99fd909fe6858c74f7b2ca0ad9772 maint-5.8-10-g5d97567 amber: Intel(R) Celeron(R) CPU 1.80GHz (i386/1 cpu) on freebsd - 9.1-RELEASE using cc version 4.2.1 20070831 patched [FreeBSD] smoketime 8 hours 33 minutes (average 28 minutes 31 seconds) Summary: FAIL(m) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), ...

Smoke [5.10.1] perl-5.10.1-1-gca8de22 FAIL(M) Solaris 2.10 (i386/1 cpu)
Automated smoke report for 5.10.1 patch ca8de220718ba91d5a5fdd9779497cd5b0250258 perl-5.10.1-1-gca8de22 unknown: i86pc (2300MHz) (i386/1 cpu) on Solaris - 2.10 using /opt/SUNWspro/bin/cc version Sun C 5.9 SunOS_i386 2007/05/03 smoketime 9 minutes 24 seconds (average 9 minutes 24 seconds) Summary: FAIL(M) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t...

Smoke [5.10.1] perl-5.10.1-RC1-30-ga3929e2 FAIL(F) netbsd 5.0.1 (i386/1 cpu)
Automated smoke report for 5.10.1 patch a3929e2d04da78f1e4fb19121feb28e87f556fb0 perl-5.10.1-RC1-30-ga3929e2 p5netbsd: Intel 686-class (i386/1 cpu) on netbsd - 5.0.1 using cc version 4.1.3 20080704 prerelease (NetBSD nb2 20081120) smoketime 7 hours 11 minutes (average 53 minutes 56 seconds) Summary: FAIL(F) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl)...

Smoke [5.10.1] perl-5.10.1-1-gca8de22 FAIL(c) freebsd 8.1-RELEASE (i386/1 cpu)
Automated smoke report for 5.10.1 patch ca8de220718ba91d5a5fdd9779497cd5b0250258 perl-5.10.1-1-gca8de22 qemu386freebsd8-1.bandsman.co.uk: QEMU Virtual CPU version 0.13.50 (i386/1 cpu) on freebsd - 8.1-RELEASE using ? unknown cc version smoketime 2 hours 33 minutes (average 1 hour 16 minutes) Summary: FAIL(c) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniper...

Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; de; rv:1.9.1) Gecko/20090624 Firefox/3.5
Name: Basti Email: sebafoatarcordotde Product: Firefox Summary: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; de; rv:1.9.1) Gecko/20090624 Firefox/3.5 Comments: Dear Ladies and Gentleman, Firefox works great and it faster than Safari, Opera and OmniWeb on my Mac Mini, thank you for the great work. I had one wish: When the download is finisched the file is in the Downloadmanger to see. It is possible that to clear with "Private .... sorry my englisch is here not so good. i hope you understand what i mean. Best Wish Browser Details: Mozilla/5.0 (Macintosh; U; ...

Error connecting MobiLink (ASA 9.01) or 2 Datebases (in asa 5.5)
Hello, wenn I try to follow the MobiLink "first-steps" example, and try to start dbmlsync -c "dsn=test_remote" -o dbmlsync.out -v I get the following error: ---------- dbmlsync.exe - Fehler in Anwendung Die Anweisung in "0x66008eb4" verweist auf Speicher in "0x00000001". Der Vorgang "read" konnte nicht auf dem Speicher ausgef�hrt werden. ----------- the End of the ML-Log is: ----------------- 52.227-19. I. 05/25 10:25:19. I. 05/25 10:25:19. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA I. 05/25 10:25...

Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1) Gecko/20090616 Firefox/3.5
Name: Jed Poster Email: jeddotposteratgmaildotcom Product: Firefox Release Candidate Summary: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1) Gecko/20090616 Firefox/3.5 Comments: Window menu often shows blank spaces. Pressing Apple+W while focused on the only tab in a window replaces the tab with a blank one instead of closing the whole window. Browser Details: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1) Gecko/20090616 Firefox/3.5 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to th...

Pb 10.5 and ASA 9.02 webservice
Hi, i am trying to use an ASA webservice as the follow: CREATE SERVICE "demo" TYPE 'dish' AUTHORIZATION OFF USER DBA USING "demo"; CREATE SERVICE "demo/getCustomer" TYPE 'soap' AUTHORIZATION OFF USER DBA AS SELECT * FROM customer ; After the create i have changed the Format of the dish service from default to 'XML' to make it visible to Pb 10.5 webservice wizard. Then i have created the Pb proxy using .Net engine . When i invoke the webservice it returns this error : There is an error in XML document (5,6) I hav...

Smoke [5.10.1] perl-5.10.1-6-ge94431a FAIL(m) netbsd 6.1.5 (i386/2 cpu)
Automated smoke report for 5.10.1 patch e94431af0ada74486afd65207f3e0345fe7485fe perl-5.10.1-6-ge94431a philips.bandsman.co.uk: Intel 686-class (i386/2 cpu) on netbsd - 6.1.5 using cc version 4.5.3 smoketime 1 minute 9 seconds (average 1 minute 9 seconds) Summary: FAIL(m) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = make test-prep perl-5.10.1-...

Smoke [5.10.1] perl-5.10.1-1-gca8de22 FAIL(F) MSWin32 WinXP/.Net SP3 (x86/2 cpu) #10
Automated smoke report for 5.10.1 patch ca8de220718ba91d5a5fdd9779497cd5b02= 50258 perl-5.10.1-1-gca8de22 maldoror.bath.planit.group: Intel(R) Core(TM)2 CPU 6700 @ 2.66GHz(~2660 MHz= ) (x86/2 cpu) on MSWin32 - WinXP/.Net SP3 using cl version 13.10.3077 smoketime 4 hours 41 minutes (average 28 minutes 11 seconds) Summary: FAIL(F) O =3D OK F =3D Failure(s), extended report at the bottom X =3D Failure(s) under TEST but not under harness ? =3D still running or test results not (yet) available Build failures during: - =3D unknown or N/A c =3D Configure,...

Smoke [5.10.1] perl-5.10.1-1-gca8de22 FAIL(F) MSWin32 WinXP/.Net SP3 (x86/2 cpu) #5
Automated smoke report for 5.10.1 patch ca8de220718ba91d5a5fdd9779497cd5b02= 50258 perl-5.10.1-1-gca8de22 maldoror.bath.planit.group: Intel(R) Core(TM)2 CPU 6700 @ 2.66GHz(~2660 MHz= ) (x86/2 cpu) on MSWin32 - WinXP/.Net SP3 using cl version 13.10.3077 smoketime 4 hours 39 minutes (average 27 minutes 56 seconds) Summary: FAIL(F) O =3D OK F =3D Failure(s), extended report at the bottom X =3D Failure(s) under TEST but not under harness ? =3D still running or test results not (yet) available Build failures during: - =3D unknown or N/A c =3D Configure,...

Upgrade from ASA 5.5 or 9 to ASE 12.5.1
Hello, is there any chance to move data and structures from SQL Anywhere 5.5 or ASA 9 to ASE 12.5.1? Or even better, directly to Oracle? Thanks, Josef This is a multi-part message in MIME format. --------------060007050104020208000608 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit JVogler wrote: > Hello, > > is there any chance to move data and structures from SQL > Anywhere 5.5 or ASA 9 to ASE 12.5.1? Or even better, > directly to Oracle? > > Thanks, Josef Hi Josef, You would export the data out t...

Web resources about - Error call UPDATEBLOB - PowerBuilder 10.5.1 (6627) and ASA 9.02 (3480) - sybase.powerbuilder.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
... Win32 or newer style .Net development After several years of work, Sybase is ready to deliver on the final step in its plan to move PowerBuilder ...

Jim O'Neil (@jimoneil) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Open Directory - Computers: Programming: Languages
about dmoz - dmoz blog - report abuse/spam - help the entire directory only in Programming/Languages Description Top : Computers : Programming ...

The HP Booth Staff (Goons) Owe Me an Apology
... when you might need to use it. For instance, when I was in the WinRunner world there were plugins for driving terminal emulators and powerbuilder ...

Contact Us - Sybase Inc
Thanks for visiting the 主页 section of Sybase.com. Here you will find information about Contact Us. For more information about Business Intelligence, ...

热门搜索 - 我的异常网
... 我的异常网 » 热门搜索 sdpnet2 移动【A111】其它用户原因鉴权失败,是什么意思啊 http:// 192.168.1.102:22578 本网站服务器位于美国,受美国法律保护 MiniUI js 破解 http://192.168.1.103:8080/ powerbuilder ...

Mobile app security: Always keep the back door locked
The best way to keep mobile apps safe is to secure the services they connect to.

10 Tech Skills That Will Instantly Net You A $100,000+ Salary
... that let's developers run Java applications. Java is highly popular language for writing web apps and custom enterprise apps. No. 8: PowerBuilder ...

Top Ranked Articles
Top Ranked Articles - Free source code and tutorials for Software developers and Architects.; Updated: 23 Feb 2013

Resources last updated: 12/4/2015 1:51:22 PM