> 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.”
> How to remove this restriction….is there any way ?
You very probably use UTF8 has the character set. So your 31000
characters become (times 4) 124000 bytes, which is too large. You
can probably shrink your values by using substring() and cast().
When I migrated my app to UTF8 I had to do things like
select cast (substring (opav2.text_value from 1 for 50) as varchar (50))
from ...
in order to get down to sizes that Firebird can handle.
HTH
Stefan
++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
