Pls-00920:parameter Plsql_native_library_dir is not set

Today, when compiling a database object, plsql error: Pls-00920:parameter Plsql_native_library_dir is not set, later found to be plsql compilation mode and setup problems, the solution is as follows.

1. Querying the Plsql property

   Show Parameter Plsql

   
   

   650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M02/9A/C1/wKioL1laEwOiRuDTAABU98yBl6A903.png-wh_500x0-wm_ 3-wmp_4-s_2694514393.png "style=" Float:none; "title=" Show parameter Plsql "alt=" Wkiol1laewoirudtaabu98ybl6a903.png-wh_50 "/>

   found that the compilation mode is native and no settings are set Plsql_native_library_dir

   
   

2. Change Plsql compilation mode

   
   

   alter system set plsql_compiler_flags=interpreted;

   650) this.width=650; "Src=" https://s5.51cto.com/wyfs02/M00/9A/C0/wKiom1laEwSBQ6hIAAAbcZiprFw924.png-wh_500x0-wm_ 3-wmp_4-s_278134924.png "title=" Alter "style=" Float:none; alt= "Wkiom1laewsbq6hiaaabcziprfw924.png-wh_50"/>
   

If the object is recompiled, no errors, no warnings occur after the operation.

Because it is not a SYS user, it only takes effect on the current session and can only be processed temporarily.

Yes, database version: 10.2.0.5.0

This article is from the "Long Way to repair ..." Blog, be sure to keep this source http://baser.blog.51cto.com/4153192/1944154

Pls-00920:parameter Plsql_native_library_dir is not set