|
|||||
|
||||||
Other Library Functions |
function |
dbOpenOCI8 |
Library: Database access (OMDB legacy)
Include: omdb.xin |
Return type: dbDatabase Returns: A dbDatabase object for the opened database connection. |
define external dbDatabase function dbOpenOCI8 value string database-name or define external dbDatabase function dbOpenOCI8 value string database-name user value string user-name password value string password
Argument definitions
Use dbOpenOCI8 to create a connection to an Oracle 8 (or higher) database. The function returns a dbDatabase OMX component.
You must include the following line at the beginning of your OmniMark program:
include "omdb.xin"
You must have an Oracle 8 (or higher) client installed on your machine, with SQL*NET configured to locate your Oracle 8 (or higher) 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 dbDatabase 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 8 (or higher) database named "DatabaseDemo" via OCI using username "charley" and password "chaplin". This connection can be reused in other omdb functions.
include "omdb.xin" process local dbDatabase my-database . . . set my-database to dbOpenOCI8 "DatabaseDemo" user "charley" password "chaplin"
Copyright © Stilo International plc, 1988-2010.