| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
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
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
![]() |
![]() |