RE: Invalid TYPE ???

You would have to specify the type IE:

        alter procedure my_object compile;

Thanks!

Christine Turner
Database Administrator
IPS-Sendero
Scottsdale, Arizona
Phone: (800) 321-6899 ext. 3286
Fax: (480) 946-8224
E-mail: christine.turner_at_ips-sendero.com

-----Original Message-----

From:	blair_at_pjm.com [SMTP:blair_at_pjm.com]
Sent:	Wednesday, August 02, 2000 9:39 AM
To:	Multiple recipients of list ORACLE-L
Subject:	Invalid TYPE ???

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