User-defined RECORD aliases

From: Ubiquitous <weberm_at_polaris.net>
Date: Wed, 25 Feb 2004 15:14:54 +0000 (UTC)
Message-ID: <c1ie5e$ia4$1@news.utelfla.com>

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 ]
Received on Wed Feb 25 2004 - 09:14:54 CST