Re: Invalid TYPE ???

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Wed, 02 Aug 2000 13:42:17 -0500
Message-Id: <10577.113644@fatcity.com>

alter type my_type compile; work for me.

Terry

blair_at_pjm.com wrote:

> I just checked for INVALID objects (desperation due to some weird errors). I
> got several object_type='TYPE' with status of invalid. What is the syntax for
> making TYPE objects valid?
>
> ALTER OBJECT MY_TYPE_OBJECT COMPILE; does not work.
>
> thanks,
>
> ..tom
>
> --
> Author:
> INET: blair_at_pjm.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 Wed Aug 02 2000 - 13:42:17 CDT