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 -> Using PLSQL Records.....

Using PLSQL Records.....

From: Miggins <mtproc_at_yahoo.co.uk>
Date: 24 Feb 2006 03:00:04 -0800
Message-ID: <1140778804.552780.65020@i39g2000cwa.googlegroups.com>


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?

Cheers Received on Fri Feb 24 2006 - 05:00:04 CST

Original text of this message

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