Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using PLSQL Records.....

Re: Using PLSQL Records.....

From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 25 Feb 2006 08:16:01 -0600
Message-ID: <ur75rica3.fsf@rcn.com>


On 24 Feb 2006, mtproc_at_yahoo.co.uk wrote:
> Each,
>
> Am considering using plsql records purely to group related variables
> together in my package. For example i may have variables to do with
> subscribtions so would create the following
>
> TYPE r_subs_rec IS RECORD (sub_date date,
> sub_amt number
> (6,2),
> sub_number integer);
>
> Instead of just creating three seperate variables......its just for
> ease of finding things and also tidyness.
>
> Anyone think this is a bad/good idea? Should I not use records for
> this reason?

Sounds reasonable to me.

-- 
Galen Boyer
Received on Sat Feb 25 2006 - 08:16:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US