Re: ???Stored Procedures In PL/SQL???

fcolon_at_onebox.com (Frank) wrote in message news:<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.

Because you mention Java I am not sure this will be of much use but try the common FAQ article on this topic, which references a web link to a Thomas Kyte article on reference cursors.

We used pl/sql tables (single dimension array) to pass record sets back to VB. The article has a code sample in VB.

http://www.jlcomp.demon.co.uk/faq/resultsets.html

• Mark D Powell --