Category Archives: Database

PLS-00970: The class name of a method must match that of EXTERNAL NAME clause in the type header

oracle

PLS-00970: The class name of a method must match that of EXTERNAL NAME clause in the type header
Cause: The class name defined as part of the method signature does not match the one defined in the type header in the EXTERNAL NAME clause. 

create type foo as object 

EXTERNAL NAME 'foo' LANGUAGE JAVA (... 

MEMBER FUNCTION my (number) return number EXTERNAL NAME 'bar.func(oracle.sql.NUMBER) return oracle.sql.NUMBER', 

...);
Action: Either omit the class name from the method signature or use the one defined in the type header.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00960: RPCs cannot use variables with schema level user-defined types in this release

oracle

PLS-00960: RPCs cannot use variables with schema level user-defined types in this release
Cause: Schema level user-defined types, or types which recursively use such types, cannot be used in RPCs. For example: 

create type foo as object (...) 

create package my_pack is 

type my_tab is table of foo; 

-- on a remote server: 

x my_pack.my_tab@rpc; -- illegal attempt to use type my_tab
Action: Use only PL/SQL-defined types for RPC calls. It may be necessary to add extra code to element-wise copy top-level types into local types in order to move such data through an RPC.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00951: string Feature is not supported by this release

oracle

PLS-00951: string Feature is not supported by this release
Cause: PL/SQL cannot understand something in an imported library unit. It uses some feature either too new or too old for this version to understand it.
Action: Recompile the imported library unit with this version of PL/SQL, to discover more precisely what feature is not supported.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement

oracle

PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement
Cause: An attempt was made to create a subtype UNDER a FINAL type. 

SELECT ename_tab.COUNT INTO name_count WHERE ...
Action: Remove the incorrect reference from the SQL statement.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00924: native compilation is not supported on this platform

oracle

PLS-00924: native compilation is not supported on this platform
Cause: Native compilation of PL/SQL programs is not supported on this platform.
Action: Compile the PL/SQL program to bytecode by setting the PLSQL_COMPILER_FLAGS initialization parameter to INTERPRETED.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00923: native compilation failed: string: string: string

oracle

PLS-00923: native compilation failed: string: string: string
Cause: The native compilation of the PL/SQL program has failed because the native shared object (DLL) could not be created successfully.
Action: The database administrator should ensure that the parameters plsql_native_c_compiler and plsql_native_linker are set correctly.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00922: parameter plsql_native_make_file_name is not set

oracle

PLS-00922: parameter plsql_native_make_file_name is not set
Cause: A PL/SQL program is being compiled natively, but the compiler parameter plsql_native_make_file_name, which denotes the full path name of the make file to make the native shared objects (DLL), is not set.
Action: The database administrator should set this parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00921: parameter plsql_native_make_utility is not set

oracle

PLS-00921: parameter plsql_native_make_utility is not set
Cause: A PL/SQL program is being compiled natively, but the compiler parameter plsql_native_make_utility, which denotes the full path name of the make utility to make the native shared objects (DLL), is not set.
Action: The database administrator should set this parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00920: parameter plsql_native_library_dir is not set

oracle

PLS-00920: parameter plsql_native_library_dir is not set
Cause: A PL/SQL program is being compiled natively, but the compiler parameter plsql_native_library_dir, which denotes the directory to store the native shared objects (DLL), is not set.
Action: The database administrator should set this parameter.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

PLS-00910: insufficient privilege to inherit from type string

oracle

PLS-00910: insufficient privilege to inherit from type string
Cause: An attempt was made to inherit from a type without the required UNDER privilege.
Action:

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/