Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Procedure status is invaid But will it atomatically vaild while execute or call this procedure from

blessed DBAMar 9 2018 — edited Mar 10 2018

select * from v$version;

1 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2 PL/SQL Release 11.2.0.4.0 - Production

3 CORE 11.2.0.4.0 Production

4 TNS for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production

5 NLSRTL Version 11.2.0.4.0 - Production

Procedure status is invalid, But will it automatically valid while execute or call this procedure from Application?

without compiling procedure will it turn automatically to valid status ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2018

Added on Mar 9 2018

#general-database-discussions

6 comments

149 views