09.07.2013 18:35, Thomas Beckmann wrote:
>
> I get this error
>
> Statement failed, SQLSTATE = 2F000
> sort record size of 187704 bytes is too big
> -Error while parsing procedure PKG$.P_SOMEPROCEDURE's BLR
>
> on recreating the package body.
It has nothing to do with the package/procedure size, it's about size of
the explicit or implicit sorting set ("select * order/group by" etc)
inside that procedure.
> Creating the procedure outside a package works fine.
That's weird. A test case would be appreciated.
Dmitry
------------------------------------------------------------------------------
See everything from the browser to the database with AppDynamics
Get end-to-end visibility with application monitoring from AppDynamics
Isolate bottlenecks and diagnose root cause in seconds.
Start your free trial of AppDynamics Pro today!
http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
