Sean Shanny wrote:
> Make sure you do not end your SQL with a ; (semi colon) as that will
> cause the fetching part not to work. Don't know why but it does. :-)
Technically, "SELECT foo;" is two statements, "SELECT foo" and "", as
JDBC doesn't require a statement terminator. The (simple-minded) JDBC
query parser doesn't do anything special to ignore trailing empty
statements. And you can't DECLARE a cursor that runs two statements.. so
the driver says "two statements, can't use a cursor!".
-O