Shulou(Shulou.com)06/01 Report--

Today, when compiling a database object, plsql reported an error: PLS-00920: parameter plsql_native_library_dir is not set. Later, it was found that it was a problem with plsql compilation mode and setup. The solution process is as follows.

Query plsql properties

Show parameter plsql

Found that the compilation mode is NATIVE and plsql_native_library_dir is not set.

Change the PLSQL compilation mode

Alter system set plsql_compiler_flags=INTERPRETED

After doing so, recompile the object without errors or warnings.

Because you are not using a sys user, only the current session is in effect and can only be processed temporarily.

By the way, database version: 10.2.0.5.0

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.