Library: Database access (OMDB) Import: omdb.xmd

Return type: dbDatabase Returns: A db.database object for the opened database connection.

Declaration

export external database function
   open-oci11g          value string dsn
                   user value string user     optional initial {  }
               password value string password optional initial {  } 

Argument definitions

dsn

is the name of the Oracle database to which you want to connect.

user

is the user name that will be supplied to the database when the connection is made.

password

is the password that will be supplied to the database when the connection is made.

Use db.open-oci11g to create a connection to an Oracle database using an Oracle 11g client installation. The function returns a db.database OMX component.

Requirements

You must have an Oracle 11g (or higher) client installed on your machine, with SQL*NET configured to locate your Oracle server.

dsn must:

• exist
• refer to an Oracle database
• be accessible via Oracle SQL*NET

user and password are optional with default values of an empty string. Check what access requirements are needed for the specified database.

Usage Notes

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.

Example #1:

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-oci11g "DatabaseDemo" user "charley" password "chaplin"

Related Topics Using the OMDB library db.open-odbc db.close db.execute-in db.query db.database db.open-table db.open-procedure db.procedure db.commit db.rollback db.compile-statement db.open-oci8i db.streaming-execute db.open-oci9i

Other Library Functions db.advance-recordset db.close db.commit db.compile-statement db.database db.delete db.discard db.document-writer-sedna db.execute db.execute-in db.field db.insert db.is-null db.move-dynamic-record db.move-record db.omdb-version db.omdb-version-oci10g db.omdb-version-oci11g db.omdb-version-oci8i db.omdb-version-oci9i db.omdb-version-odbc db.omdb-version-sedna db.open-oci10g db.open-oci11g db.open-oci8i db.open-oci9i db.open-odbc db.open-procedure db.open-sedna db.open-table db.prepare db.procedure db.query db.reader db.record-exists db.rollback db.set-transaction-type db.statement db.streaming-execute db.table db.update db.writer

[ INDEX ] [ CONCEPTS ] [ TASKS ] [ SYNTAX ] [ LIBRARIES ] [ LEGACY LIBRARIES ] [ ERRORS ]