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
BINARY_INTEGER index.
You could easily fix this by finding an assignment statement elsewhere in
your code to see what you are trying to store.
hope this helps
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Friday, July 27, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L
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/41 PLS-00206: %TYPE must be applied to a variable, column, field or
attribute, not to "UC9_CLAIM_AMOUNT"
The source is listed below. uc9_correspondence is table in my schema. I do
not know why this is throwing up an error where as 734
was happy with it.
TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%TYPE
INDEX BY BINARY_INTEGER;
Any help is appreciated
Thanks in ADvance
deen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deen Dayal
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
