Hi,

I got the questions , I would like to retrieve the array of data's
using stored procedure, I believe there must be
Someway to do it?.

I don't understand your reply below one.

Regards,
N.Paul


-----Original Message-----
From: Roman Rokytskyy [mailto:rrokytskyy@...]
Sent: Tuesday, 25 May 2004 6:15 PM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: Stored procedure and array

Hi,

> I know Jaybird 1.0.1 doesn't support array datatype.
>
> Anyway, is it possible to use with jaybird a selectable procedure
> which returns some integer values and an integer array value? I don't
> want to get this array value in my java application, I'll just
> retrieve the integer values.
>
> Could it be any problem?

You have to use following syntax:

SELECT myIntColumn FROM mySelectableProc(?, ...)

If you keep using {call ...} syntax, JayBird will throw an exception.
If using escaped syntax is a must, wrap your procedure with another one:

CREATE PROCEDURE myWrapperProcedure (....) RETURNS (myIntColumn INTEGER)
AS BEGIN
SELECT myIntColumn FROM mySelectableProc(...) INTO :myIntColumn;
/* This is needed only if you want it to be selectable */
SUSPEND;
END

Roman





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=1294bkmml/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705006764:HM/EXP=1085566569/A=2128215/R=0/SIG=10se96mf6/*http:/c
ompanion.yahoo.com> click here


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=391391703>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Firebird-Java/

* To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com
<mailto:Firebird-Java-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]