Re: How to pass a record to a Procedure

From: Watson Davis <watson_at_watsonmusic.com>
Date: 2 Dec 2004 07:00:42 GMT
Message-ID: <Xns95B2EA4A8A708thepencilneckyahooco@206.66.12.202>

keith_newsg_at_yahoo.ca (Keith) wrote in news:f1c2be54.0411161206.457669c6 @posting.google.com:

> I have a very large program (2000+ lines) and I want to try to break
> it down into smaller pieces, make it more modular. I have a cursor
> with 80 fields. While in the cursor loop, I want to call a procedure
> and pass the whole cursor record. It will do some processing on the
> record and then return the record to the calling procedure so that the
> updated values can be used. How can I do this?

There are several ways you can do this. Keeping your code just the way it is, just replace your SomeTpyeOfRec with rmp_table%type.

You could also package this and pull the cursor declaration outside of proc1, and then replace SomeTpyeOfRec with emp_cursor%type.

Watson (the pencil neck) Davis Received on Thu Dec 02 2004 - 01:00:42 CST