|
|||||
|
||||||
Related Topics | Other Library Functions |
function |
db.open-oci10g |
Library: Database access (OMDB)
Import: omdb.xmd |
Return type: dbDatabase Returns: A db.database object for the opened database connection. |
define external db.database function db.open-oci10g value string database_name or define external db.database function db.open-oci10g value string database-name user value string user-name password value string password
Argument definitions
Use db.open-oci10g to create a connection to an Oracle database using an Oracle 10g client installation. The function returns a db.database OMX component.
You must have an Oracle 10g (or higher) client installed on your machine, with SQL*NET configured to locate your Oracle server.
database-name must:
user-name and password are optional with default values of an empty string. Check what access requirements are needed for the specified database.
You must have declared an OMX db.database variable (either global or local) to reuse a database connection in other OMDB functions.
This function will throw external exception OMDB501 if there are any OCI errors. The exception will include any error numbers and descriptive text generated by the OCI. Consult your Oracle documentation for further details on the error condition.
Create a connection to an Oracle database named "DatabaseDemo" via OCI using username "charley" and password "chaplin". This connection can be reused in other OMDB functions.
import "omdb.xmd" prefixed by db. process local db.database my-database . . . set my-database to db.open-oci10g "DatabaseDemo" user "charley" password "chaplin"
Copyright © Stilo International plc, 1988-2010.