Re: [firebird-support] Block size exceeds implementation restriction exception for varchar(31000)

2016-09-08 Thread Stefan Heymann li...@stefanheymann.de [firebird-support]
> I want to alter an existing stored procedure with varchar > parameters having length of 31000. Whenever I try to execute this query I get > an exception of > “Invalid token. Invalid request BLR at offset 102. Implementation limit > exceeded. Block size exceeds implementation restriction.” >

RE: [firebird-support] Re: Block size exceeds implementation restriction exception for varchar(31000)

2016-09-08 Thread 'Joje' j...@codework-solutions.com [firebird-support]
Thanx Jez. I will have to modify the stored procedure. Thank you once again. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 08 September 2016 16:41 To: firebird-support@yahoogroups.com Subject: [firebird-support] Re: Block size exceeds imp

[firebird-support] Re: Block size exceeds implementation restriction exception for varchar(31000)

2016-09-08 Thread 'Jeremy Poppleton' jeremy.popple...@csy.co.uk [firebird-support]
Firebird has limitation on both IN clauses and parameter lists for stored procedures. Going down the route of trying to get around this can then cause errors with the command text limit. It is always best to redesign your stored procedure or query to join on a table that has the particular par

[firebird-support] Block size exceeds implementation restriction exception for varchar(31000)

2016-09-08 Thread 'Joje' j...@codework-solutions.com [firebird-support]
Hi All, I want to alter an existing stored procedure with varchar parameters having length of 31000. Whenever I try to execute this query I get an exception of "Invalid token. Invalid request BLR at offset 102. Implementation limit exceeded. Block size exceeds implementation restriction."

[firebird-support] Firebird crash on FreeBSD

2016-09-08 Thread respekt...@post.cz [firebird-support]
Hello, we have one customer using FreeBSD and Firebird 2.5.4 It works fine till this week when firebird crashes twice. In Firebird.log i found this text verbis Mon Sep 5 22:44:01 2016 Operating system call semaphore.h: release: sem_post() failed. Error code 22 verbis Mon Sep 5 22:44:01 2016