Oracle
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:
- The Database component, documented below. Requirements: client and PHP PDO extension.
- PHP functions, documented here. Requirements: client and PHP extension.
Contents
Installation
Client
- Get the Instant Client from here.
- Extract the archive.
- 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.dll→extension=php_pdo_oci.dll
- For HTML5 Builder’s internal server, apply the changes to the php.ini.template file.
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.dll→extension=php_oci8.dll
- For HTML5 Builder’s internal server, apply the changes to the php.ini.template file.
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.