Subject Re: Please Help. How to call a Stored Proc. in JAVA that returns mulitple records?
Author olan_rolando
Hi Rick,

Thanks for the links, i got some problems fixed but still i can't
fixed my problem regarding calling a stored procedure that should
return a resultset with multiple records and not just one record.
(FOR SELECT DO...SUSPEND in the Stored Proc). I already tried the
CALLABLESTATEMENT and the PreparedStatement. Te CALLABLESTATEMENT
only works on returning one record, while the PreparedStatement
can't handles an Statement like this "SELECT * FROM STOREDPROC
(?, ?)", an sql statement that calls a stored procedure with an IN
parameters.

Please help me, 'cause I do prefer coding in Stored Procedure rather
putting it in Java as Prepared Statement or SQL Statement.

Always,
Olan

--- In Firebird-Java@yahoogroups.com, Rick Fincher <rnf@...> wrote:
>
> Hi Olan,
>
> Check these web sites for info on stored procedures. What you
probably
> want are Select procedures. They are called like a select
statement and
> return a ResultSet.
>
> http://forum.java.sun.com/thread.jspa?forumID=48&threadID=294847
> http://www.destructor.de/firebird/storedproc.htm
>
> Hope This helps.
>
> Rick
>
> olan_rolando wrote:
>
> > Please help me, I'm new with JAVA programming and I'd like to
know how
> > to call a Stored Procedure with multiple record results and put
it in
> > a combo box.
> >
> > Note: I'm using the Jaybird driver 2.0.1 JDK 1.5 and connecting
using
> > DataSource.
> >
> > Thank you in advanced and more power.
> > Olan
> >
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>