Re: Stored Procedure Examples

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

Look up REF CURSOR in a good PL/SQL book.

And you are correct. Oracle handles just about everything differently from SQL Server. Like platform compatibility, operating system compatibility, stability, security, scalability, record locking, and performance.

You can't get Oracle's advantages without Oracle.

Daniel A. Morgan Received on Mon May 21 2001 - 23:56:06 CDT