:
[EMAIL PROTECTED]Subject: PL/SQL Question after migrating
from
om7.3.4 to 8.1.7
07/27/2001
01:45 PM
Please respond
to ORACLE-L
Hi,
I just
Hi,
I just migrated from 734 to 817, I used migration utility. Migration went fine. Some
of my package specification have become
invalid.
When I tried to recompile, I got the following error
30/41PLS-00206: %TYPE must be applied to a variable, column, field or
attribute, not to
Deen,
shouldn't the statement be:
TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence.COLUMN_NAME%TYPE
INDEX BY BINARY_INTEGER;
??
The %TYPE in your PL/SQL is being applied to the table which, I think, is
not valid. A PL/SQL table is a one-column data type, indexed via the
Deen,
If you want a table with the structure of a row in your uc9_correspondence, use THE
'%ROWTYPE'as follows:
TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE
INDEX BY BINARY_INTEGER;
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
:
[EMAIL PROTECTED]Subject: PL/SQL Question after migrating
from
om7.3.4 to 8.1.7