<div>
You can't avoid it, &nbsp;if you modify a plsql object, either explicity or implicitly (by modifying objects it's dependent on) then that object will need to be recompiled.<br />
Upgrading to 11g will help because it does finer grained dependencies but if procedure is dependent on an object then you will encounter 4068's if you try to use it across ddl changes.<br />
<br />
A simple refresh of data shouldn't cause any invalidations though
</div>


You can't avoid it,  if you modify a plsql object, either explicity or implicitly (by modifying objects it's dependent on) then that object will need to be recompiled.
Upgrading to 11g will help because it does finer grained dependencies but if procedure is dependent on an object then you will encounter 4068's if you try to use it across ddl changes.

A simple refresh of data shouldn't cause any invalidations though

<div>
if you don't have further info request, I suggest deleting the question rather than closing it 
</div>


if you don't have further info request, I suggest deleting the question rather than closing it

<div>
It's not very elegant, but it'll work.
</div>


<div>
<div class="content wysiwyg-content">
I need to update/refresh a materialized view that is the basis for records processed by a procedure. Any way to do this in PL/SQL?
</div>
</div>


I need to update/refresh a materialized view that is the basis for records processed by a procedure. Any way to do this in PL/SQL?

How to avoid ORA-04068, but still update materialized view that is used in a procedure?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.