Oracle

From HTML5 Builder
Jump to: navigation, search

Oracle is an object-relational database management system developed by Oracle.

There are different technologies you can use to access Oracle from web applications developed with HTML5 Builder:

Installation

Client

  1. Get the Instant Client from here.
  2. Extract the archive.
  3. Get your system to recognize the .dll files in the Instant Client folder. There are two different ways you can achieve this:
    • Copy all .dll files from the Instant Client folder into your Windows\System32 directory.
    • Point ORACLE_HOME to the Instant Client folder. Check this for more information.

PHP PDO Extension

Enable the extension by uncommenting (removing the ; at the beginning) the following line in PHP’s configuration file (php.ini):

;extension=php_pdo_oci.dllextension=php_pdo_oci.dll

PHP Extension

Enable the extension by uncommenting (removing the ; at the beginning) the following line in PHP’s configuration file (php.ini):

;extension=php_oci8.dllextension=php_oci8.dll

Note: For Ubuntu servers, follow the steps here.

Configuration

Tip: You can use the Data Explorer to configure your Oracle connections the RAD way.

To use a Database component with Oracle, configure it with the following property values:

  • DriverName: oracle.

Then fill the rest of the mandatory properties as required.

Help Resources

Documentation

See Also