Stored Procedure Examples

I'm looking for a few good examples of stored procedures that return recordsets. I come from the MS world, and it looks as if Oracle handles recordsets very differently as return values from stored procedures. I am unable to locate any examples from Oracle, and a few from some publishers, but the examples are lacking and sort 'Hello Worldish' I am looking specifically for stored procedures that are accepting multiple values, but do not require all of them, for example;

I have a table of personnel. I want to be able to pass an employee id, first name, and / or last name to one procedure that will find the personnel that match one, two or three of the parameters I've passed it. In MS SQL I would use the datalength() to see if the param is null and build a string variable to exec(). It doesn't look like I can do this in Oracle. Help? I am a total newbie with Oracle and need a little guidance.

Thanks in advance. Received on Mon May 21 2001 - 21:31:52 CDT