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

From: Deen Dayal <ddayal_at_dol.state.nj.us>
Date: Mon, 30 Jul 2001 07:47:31 -0700
Message-ID: <F001.00358EE6.20010730075751@fatcity.com>

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-----

Prasada.Gunda1_at_hartfordlife.com
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"
                    <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).

--

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 Mon Jul 30 2001 - 09:47:31 CDT