???Stored Procedures In PL/SQL???
From: Frank <fcolon_at_onebox.com>
Date: 15 Aug 2001 14:22:48 -0700
Message-ID: <3271719f.0108151322.4be9dc82_at_posting.google.com>
Date: 15 Aug 2001 14:22:48 -0700
Message-ID: <3271719f.0108151322.4be9dc82_at_posting.google.com>
I need to write a stored procedure in PL/SQL that returns a set of
records.
For example, lets say I write a procedure that searched all employees
in my database who have a first name of "Ted".
If the query in my procedure returns 4 records, how do I get it so
that procedure can return that result set (all 4 records) to the
calling program?
Eventually the stored procedure will be called from a Java program via
JDBC, and that Java program will need the entire result set.
Can someone give me a few pointers? Thanks.