Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 12 of 20
filespec: See "filespec".
To create a schema object associated with an operating-system shared library. The name of this schema object can then be used in the call_spec of CREATE
FUNCTION
or CREATE
PROCEDURE
statements, or when declaring a function or procedure in a package or type, so that SQL and PL/SQL can call to third-generation-language (3GL) functions and procedures.
See Also:
"CREATE FUNCTION" and PL/SQL User's Guide and Reference for more information on functions and procedures. |
To create a library in your own schema, you must have the CREATE
LIBRARY
system privilege. To create a library in another user's schema, you must have the CREATE
ANY
LIBRARY
system privilege. To use the procedures and functions stored in the library, you must have EXECUTE
object privileges on the library.
The CREATE
LIBRARY
statement is valid only on platforms that support shared libraries and dynamic linking.
The following statement creates library EXT_LIB
:
CREATE LIBRARY ext_lib AS '/OR/lib/ext_lib.so';
The following statement re-creates library EXT_LIB
:
CREATE OR REPLACE LIBRARY ext_lib IS '/OR/newlib/ext_lib.so';
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|