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

Home -> Community -> Usenet -> c.d.o.server -> Procedures become invalid after rdbms/admin scripts

Procedures become invalid after rdbms/admin scripts

From: David Van Zandt <dvanzandt_at_iquest.net>
Date: 2000/03/08
Message-ID: <38C714CD.B8F7F7B0@iquest.net>#1/1

Hi all, I find that when I run the catalog through repcat - type scripts against an instance, a number of the procedures, packages, etc. become invalid. It's simple enough to recompile them, but perhaps I'm doing something wrong or unnecessary? I run the set of scripts, rightly or wrongly, following a DDL change to a schema's objects.

Thanks in advance,
Dave Received on Wed Mar 08 2000 - 00:00:00 CST

Original text of this message

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