'execute statement' with blob
------------------------------
Key: CORE-4374
URL: http://tracker.firebirdsql.org/browse/CORE-4374
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 3.0 Alpha 2
Environment: Firebird-3.0.0.30988-0_x64
Reporter: Alex Bekhtin
In 3.0 we can create big PSQL-code, but can't call 'execute statement' with big
code contained in blob
---
execute block
returns (SQL blob sub_type text)
as
begin
select 'create or alter procedure test_proc returns(id integer) as begin '||
list('SUSPEND;', '
')||'
end' from rdb$types, rdb$types
rows 35000
into :SQL;
execute statement :SQL;
suspend;
end
------------------
Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
blob truncation when converting to a string: length limit exceeded.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
