Subject | Re: Possible bug with Jaybird and StoredProcedure w/Variable call |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-06-10T22:52:15Z |
> I may have found a bug with Jaybird 1.5 RC3. I have an existingYes, that's a bug. I have implemented parser for {call ...} syntax,
> application that executes a stored procedure with a single varchar
> variable. The call is "execute procedure get_lo_id 'SJARDINE'" and
> it returns a result that is stored in new_load_id. It works in
> Jaybird 1.0.? but fails in Jaybird 1.5 RC3. I have been doing my
> testing on Intel P4/Windows XP/JDK1.4.2 and Intel P4/Debian
> Linux/JDK1.4.2. I have included my stack trace with my example
> code. Please let me know what you think and if you need additional
> information. Thanks.
but in order to maintain compatibility with 1.0.x it had also accept
EXECUTE PROCEDURE syntax. Yet another bug in parser.
Please put parameter in parenthesis before the bug is fixed and vew
version is released:
execute procedure get_lo_id('SJARDINE')
Thanks!
Roman