Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Returning more than a sigle variable from a stored function and recive the information in a JDBC Servlet

Returning more than a sigle variable from a stored function and recive the information in a JDBC Servlet

From: Mattias Malmgren <a2matmal_at_ulmo.stud.slu.se>
Date: Tue, 23 Jun 1998 17:12:28 +0200
Message-ID: <358FC5DC.D0C23173@ulmo.stud.slu.se>


I need help on writing a stored funtion i Oracle and then use it in a JDBC servlet.

How do I get a servlet to get multipel rows and cols from a stored function?

I can get a sigle telephone number from a stored function and then display it
as you can see here:
http://mattias.kontakt.slu.se:8001/servlets/tele4 all this works perfectly fine. (text in swedish, but just chose a name from
the selection-list press the button "Fraga")

But how do I make a stored function that returns and a JDBC servlet that

recives all the information in the table:

SQL> select * from telbok;

NAME                 NR
-------           ---------
Mattias               67 17 85
Stefan                 67 30 20
Rolf                    67 19 92

I have looked a little at CURSOR's but I didn't realy understand it. HELP!!! Greetings / Mattias Received on Tue Jun 23 1998 - 10:12:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US