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/41PLS-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).
Re: PL/SQL Question after migrating from 7.3.4 to 8.1.7
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: 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).
Re: PL/SQL Question after migrating from 7.3.4 to 8.1.7
Use %ROWTYPE. TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE INDEX BY BINARY_INTEGER; hth, prasad "Deen Dayal" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L ate.nj.us><[EMAIL PROTECTED]> Sent by: cc: [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 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 "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: 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).
RE: PL/SQL Question after migrating from 7.3.4 to 8.1.7
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_correspondence%ROWTYPE INDEX BY BINARY_INTEGER; hth, prasad "Deen Dayal" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L ate.nj.us><[EMAIL PROTECTED]> Sent by: cc: [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 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 "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: 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: 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).