| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: PL/SQL Question after migrating from 7.3.4 to 8.1.7
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: ddayal_at_dol.state.nj.us
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Fri Jul 27 2001 - 12:32:40 CDT
 |
 |