Saturday, July 5, 2008

Native PL/SQL Compilation on R12

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: