Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: PL/SQL Question after migrating from 7.3.4 to 8.1.7

Re: PL/SQL Question after migrating from 7.3.4 to 8.1.7

From: <Prasada.Gunda1_at_hartfordlife.com>
Date: Fri, 27 Jul 2001 12:29:42 -0700
Message-ID: <F001.00357B80.20010727113647@fatcity.com>

Use %ROWTYPE.

TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE

        INDEX BY BINARY_INTEGER; hth,
prasad

                                                                                       
        
                    "Deen Dayal"                                                       
        
                    <ddayal_at_dol.st        To:     Multiple recipients of list ORACLE-L 
        
                    ate.nj.us>            <ORACLE-L_at_fatcity.com>                       
        
                    Sent by:              cc:                                          
        
                    root_at_fatcity.c        Subject:     PL/SQL Question after migrating 
from    
                    om                    7.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/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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Prasada.Gunda1_at_hartfordlife.com 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 - 14:29:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US