Oracle recommends PL/SQL compilation (plsql_code_type) to NATIVE. I have tried and I encountered many errors. Almost every script involving PL/SQL code end with ORA-06502.
Programs such as Validate Application Accounting Definition and patch wizard analyze program ended with error. So I changed back to INTERPRETED. Errors are gone.
Maybe I missed something when I set PL/SQL compilation to NATIVE. Until I know what cause the error, I will stick to INTERPRETED
No comments:
Post a Comment