> while the PreparedStatement can't handles an Statement like this

"SELECT * FROM STOREDPROC (?, ?)"

Please post the code that fails, and the exception that is thrown. This
should work.

-----Original Message-----
From: Firebird-Java@yahoogroups.com
[mailto:Firebird-Java@yahoogroups.com] On Behalf Of olan_rolando
Sent: Thursday, July 06, 2006 9:22 AM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: Please Help. How to call a Stored Proc. in
JAVA that returns mulitple records?

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]
>






------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Groups gets a make over. See the new email design.
http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links