That worked, Thanks a lot for all the replies. I was just wondering how it worked on
version 7.3.4
Thanks
deen
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, July 27, 2001 3:37 PM
To: Multiple recipients of list ORACLE-L
Use %ROWTYPE.
TYPE tb_uc9_corres_type IS TABLE OF uc9_corr
Use %ROWTYPE.
TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE
INDEX BY BINARY_INTEGER;
hth,
prasad
"Deen Dayal"
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:
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
BINAR
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 "UC