Re: Oracle Types and ROWID and PL/SQL tables

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Fri, 17 Aug 2001 16:28:46 GMT
Message-ID: <3b7d4358.897035@news>

On 17 Aug 2001 08:49:59 -0700, christophertava_at_hotmail.com (Christopher Tava) wrote:

>Does anyone know if you can use pl/sql tables in a user defined type?

PL/SQL tables are different from ORACLE collection types. They are defined as user types using the TYPE command, but inside PL/SQL programs, not in the dictionary. Having said that, VARRAY and nested tables in PL/SQL are almost equivalent to the types of same name in SQL (which are defined by CREATE TYPE).

>Does anyone know if you can use rowid in a user defined type?
>

I'm not sure. The PL/SQL manual has a description of the datatypes that can be used inside a TYPE.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Fri Aug 17 2001 - 11:28:46 CDT