Re: PL/SQL and Java

I don't know about java, but if you pass variables to a function by reference in C/C++, you can get the same result as returning multiple values. You just pass references to all of the return values, and then set them in the sub, and if you pass them by reference, you actually set the value in the correct memory location, not a copy of hte value. You my need to global-ize some of the variables that you need to set in java.

Or maybe have several vars of type Object that are global, and you can set them in the sub, and cast them into whatever you need. This should be allowed, since everyting inherits from Object...Right?

krao wrote:
>
> I think what Henrik, who obviously is not a native speaker of English (like
> myself), meant was that his Jave code can not handle multiple return values from
> the stored procedure. When I first read his message, I thought along the same
> lines Mladen did. But, when I re-read and noticed the usage of "answer" in the
> third sentence, it wasn't difficult to understand what he meant.
>
> - kr
>
> -----Original Message-----
> Mladen
> Sent: Monday, December 04, 2000 10:20 AM
> To: Multiple recipients of list ORACLE-L
>
> Well, he can read only one answer today and this answer
> can cover pretty much everything. Don't you think that this
> is the most optimal use of his resources?
>
> -----Original Message-----
> Sent: Monday, December 04, 2000 11:05 AM
> To: Multiple recipients of list ORACLE-L
>
> Mladen, the answer is always 42 correct?
>
> joe
>
> "Gogala, Mladen" wrote:
> >
> > The answer is 42.
> >
> > -----Original Message-----
> > Sent: Friday, December 01, 2000 10:01 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > Hello,
> >
> > I have a PL/SQL procedure that send me one unique number.
> > Sometime I can receive more than one number back.
> > How can I read all this answer from Java ? Have someone a hint. Today I
> can
> > only read one answer.
> >
> > Regards
> > Henrik
> >
> >
> --
> Joe Testa http://www.oracle-dba.com
> No you can't fix an ORA-600 error, call Oracle Support.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: krao
> INET: krao_at_callidussoftware.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Mon Dec 04 2000 - 16:53:44 CST