Name Name wrote:
>
> Hi, I am calling a Oracle Stored Procedure which returns VARRAYS. I am
> converting Oracle VARRYS into Java String ARRAYS and displaying the data on
> the screen. But as the records may be in large number, i want to implement
> paging.
>
Each email to the servlet-interest list is saved off in
a big searchable database, or archive. It is considered
polite to search the mailing list archive before you post
a question, because chances are your question has been
asked and answered already.
For example, the display-results-page-by-page question
was asked yesterday, and there are some good answers in the
archives.
Checking the archives benefits everyone: you get a fast,
complete answer to your question (no waiting for others
to answer) and the rest of us avoid reading the same
questions over and over (and over and over) again.
> I tried the following approach:
> ...
> Do i need to pass the whole data in SESSION and access that the next time???
> Is it the right method??
>
> Can i Pass the CallableStatment as a session variable and then retrieve the
> data from it the next time???
>
Both of the above are possibilities, but you have to
be careful of things like timeouts, and the performance
effect of keeping queries open for a (potentially) long
period of time, and the possibility of using up really
huge amounts of memory, etc. There isn't a single best
answer, it depends on your exact requirements.
> Please Send a SAMPLE CODE, it is of great help to me.
>
Please check THE ACHIVES, they will be of great help
to you. There are several threads that discuss your
problem and several possible solutions, but you may
have to spend some time searching the archives to find
all the relevant information.
-cks
___________________________________________________________________________
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
