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

Home -> Community -> Usenet -> c.d.o.misc -> Re: User-defined RECORD aliases

Re: User-defined RECORD aliases

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 25 Feb 2004 08:16:14 -0800
Message-ID: <1077725736.909468@yasure>


Ubiquitous wrote:

> This might be a silly question but can one assign aliases to the rows
> of a user-defined record that is based on an existing table using ROWTYPE?
> I am asking because the table upon which it based has long names which
> are causing "name too long" type errors when I try to access them.
>
> Example:
> closeout_detail_rec closeout_detail%ROWTYPE
>
> [ later..]
>
> IF closeout_detail_rec.fee_amount_charged > 100.00 THEN
>
> [causes a "variable name is too long" ORACLE error ]

Why not just do this?

co_det_rec closeout_detail%ROWTYPE;

?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Feb 25 2004 - 10:16:14 CST

Original text of this message

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