Subject Re: [firebird-support] Execute Statement fails on application but Ok in IBExpert
Author Dmitry Sibiryakov
On 19 Oct 2005 at 16:14, Steve Harp wrote:

>I have a selectable stored procedure that uses EXECUTE STATEMENT. In
>my application, the stored procedure fails with an error,
>"ISC ERROR CODE:335544829
>Variable type (position 1) in EXECUTE STATEMENT 'select ord.OrderID,
>ord.OrderTypeID, ord.Customer,' INTO does not match return".

First variable in INTO clause does not match type of ord.OrderID.
EXECUTE STATEMENT in contrast with other assignments does not perform
type coerce.

>However, I can pass exactly the same string to IBExpert and run the
>stored procedure in the debugger and it runs clean and returns the
>correct result set.

Complain to IBExpert team that their FB emulator does not emulate
FB behavior exactly.

SY, Dimitry Sibiryakov.