Re: Stored Procedure Examples

A copy of this was sent to "John Doe" <jdoe_at_home.com> (if that email address didn't require changing) On Tue, 22 May 2001 02:31:52 GMT, you wrote:

>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.
>

see
http://asktom.oracle.com/~tkyte/ResultSets/index.html

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp