Oracle DB

From DreamFactory
Jump to: navigation, search
(Configuration)
Line 20: Line 20:
 
* '''attributes''' - Object. Optional. A key-value array of attributes to be set after connection. For further information, see http://php.net/manual/en/pdo.setattribute.php.
 
* '''attributes''' - Object. Optional. A key-value array of attributes to be set after connection. For further information, see http://php.net/manual/en/pdo.setattribute.php.
 
* '''statements''' - Array of Strings. Optional. An array of additional SQL statements to run during connection initialization.
 
* '''statements''' - Array of Strings. Optional. An array of additional SQL statements to run during connection initialization.
 +
 +
==Errors==
 +
If you want to change the default way Date is returned you can change it via adding it to Additional SQL Statements
 +
* <code>ALTER SESSION SET NLS_DATE_FORMAT = ‘DD/MM/YYYY HH24:MI:SS’</code>

Revision as of 18:07, 19 December 2018

The Oracle service type can connect to local or remote Oracle Database servers.

Common Feature Exceptions

Requirements

  • PHP extension oci8 is required to be installed or compiled in. Check here for installation help.

Configuration

  • host - String. Required. The name of the database host, i.e. localhost, 192.168.1.1, etc.
  • port - Integer. Optional. The number of the database host port, internally defaults to 1521.
  • database - String. Required. The name of the database (aka SID) to connect to on the given server. This can be a lookup key.
  • username - String. Optional. The name of the database user. This can be a lookup key.
  • password - String. Optional. The password for the database user. This can be a lookup key.
  • default_schema_only - Boolean. Defaults to false. Do not include other schemas/databases on this server regardless of permissions given to the supplied credentials.
  • tns - String. Optional. TNS full connection string which overrides all other host, port, etc. settings.
  • protocol - String. Optional. Connection Protocol, internally defaults to TCP.
  • charset - String. Optional. The character set to use for this connection, internally defaults to AL32UTF8.
  • service_name - String. Optional. Optional service name if database (i.e. SID) is not set.
  • options - Object. Optional. A name-value array of driver-specific connection options.
  • attributes - Object. Optional. A key-value array of attributes to be set after connection. For further information, see http://php.net/manual/en/pdo.setattribute.php.
  • statements - Array of Strings. Optional. An array of additional SQL statements to run during connection initialization.

Errors

If you want to change the default way Date is returned you can change it via adding it to Additional SQL Statements

  • ALTER SESSION SET NLS_DATE_FORMAT = ‘DD/MM/YYYY HH24:MI:SS’