Hi All,

I want to call a stored procedure, which is having a query which return a
set of rows(say 10 records),
instead of putting the query in the servlets I want to put it in a stored
procedure and call a stored
procedure. One of the parameter for procedure is IN OUT and is table type,
which is a oracle datatype.
How do I this using stored procedure?

Or Is there is any other way to do this, my aim is not to put any queries in
the servlets and all the
database queries in the stored procedure. Is there any way to do this?

Waiting for your replies.

Thanks in advance.

Bye
Srikanth

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to