From Xojo Documentation

You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!

Class (inherits from Database)

Use with the Oracle plug-in to connect to an Oracle database.

DatabaseName Host Password
Debug MultiThreaded UserName
AddRow Connect SelectSQL
BeginTransaction ExecuteSQL TableColumns
Close Prepare TableIndexes
CommitTransaction RollbackTransaction Tables


Oracle 8i and above are supported. The Oracle OCI client 9i or later must be installed.

In order to use this class, you must have the OraclePlugin database plug-in in your plugins folder.

The OracleDatabase engine supports all four RecordSet navigation methods: MoveFirst, MoveNext, MovePrevious, and MoveLast.


SQLSelect and SQLExecute statements do not block when called from within Threads.

Xojo Cloud

Oracle databases cannot be accessed from Xojo Cloud.


In order to use OracleDatabase, you need to install the Oracle Instant Client which can be downloaded from here:

You'll also need to make sure that your system path contains the folder with the Oracle Instant Client.

Sample Code

The following code connects to an Oracle Express database hosted at

db = New OracleDatabase

db.UserName = "SYSTEM"
db.Password = "dbexample"
db.Debug = 1

MessageBox("Connected to Oracle!")
Catch error As DatabaseException
MessageBox("Error connecting to Oracle: " + error.Message)
End Try

See Also

Database, DatabaseRow, OracleSQLPreparedStatement, PreparedSQLStatement, RowSet classes.