java + stored procedure

Hi,

    I'm trying to create a stored procedure which executes a SELECT request and give the result as if I directly request the DB with a SQL statement.

                something looking like that:

                        procedure test is
                        begin
                                -- some stuff here
                                select * from table1;
                        end;

    How can I do that ?

Stephane. Received on Mon Feb 12 2001 - 11:32:18 CST