Re: PL/SQL - Pass Cursor Record as Parameter?

David Ward wrote:
>
> Hi,
>
> I am working on a procedure in which a cursor is created to hold the
> contents of a temporary table.
>
> I loop through the cursor, fetching the contents of the cursor into a
> record each time. If certain conditions are met in the current record, I
> would like to pass the entire record as a parameter to another
> procedure.
>
> Can this be done? I cannot seem to find any examples of this, so I am
> not sure what syntax to use to specify the curent record.
>
> Thanks,
>
> Dave

Have a look at REF CURSORS for passing an entire cursor from one proc to another, and have a look at %ROWTYPE variables for passing entire rows from one proc to another

HTH

-- 
==============================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"
				- Salvador Dali