Re: [Firebird-devel] Cannot use stored procedures in FireBird Server

[Dmitry Y. <fir...@ya...>]

dandreikin wrote:
> We have the application that uses Firebird 2.0.3 Server and accesses to is
> through ODBC (Firebird driver 1.2).
> When application creates stored procedures under restricted (non-SYSDBA)
> user and then tries to execute some of them 
> under restricted user, function that called execution hangs with no result.
> Also such query: UPDATE <sometable> SET BLOCK = (SELECT BLOCK FROM
> <anothertable> WHERE <someUID> = 1) WHERE <someUID> = 1" hangs,
> where BLOCK is binary BLOB.
> 
> Is there any solution or workaround for this?

Maybe it's worth trying to post to the ODBC driver mailing list instead? 
Or can you reproduce these issues with some non-ODBC tool, like IBExpert 
or DatabaseWorkbench or FlameRobin?


Dmitry