Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: User-defined RECORD aliases
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