Re: Is it possible to anchor to a user-defined record element?

I should have been more clear: I'm wondering if this can be done withOUT having to create an instance of the type? Furthermore, what I really want to do is have this as part of a PL/SQL table:

declare

   type typView is record (Name varchar2(255));    type typtabListView is table of typView index by binary_integer;    tabListView typtabListView;

   sNameView <-- How to anchor to the Name attribute? begin

   null;
end;

"John Peterson" <johnp_at_azstarnet.com> wrote in message news:tvo241q9eko074_at_corp.supernews.com...
> (Oracle 8.1.7 on Win2K Pro)
>
> Hello, all!
>
> I'm trying to figure out how to create a variable whose type is anchored
to
> a user-defined record element. For example, I would have thought that
this
> would have worked:
>
> declare
> type typView is record (Name varchar2(255));
>
> sNameView typView.Name%type;
> begin
> null;
> end;
>
> But it doesn't. ;-)
>
> I would welcome any ideas and/or suggestions. Thanks in advance! :-)
>
> John Peterson
>
>
Received on Wed Nov 21 2001 - 14:43:12 CST