| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> PL/SQL Question after migrating from 7.3.4 to 8.1.7
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). Received on Fri Jul 27 2001 - 11:41:37 CDT
 |
 |