/**
* Constructor opens a connection to the database
* @param string $module Module text for End-to-End Application Tracing
* @param string $cid Client Identifier for End-to-End Application Tracing
*/
function __construct($module, $cid)
{
$this->conn = @oci_pconnect(SCHEMA, PASSWORD, DATABASE, CHARSET);
if (!$this->conn) {
$m = oci_error();
throw new \Exception('No se puede conectar a la base de datos: ' . $m['message']);
}
// Record the "name" of the web user, the client info and the module.
// These are used for end-to-end tracing in the DB.
oci_set_client_info($this->conn, CLIENT_INFO);
oci_set_module_name($this->conn, $module);
oci_set_client_identifier($this->conn, $cid);
}
/**
* Constructor opens a connection to the database
* @param string $module Module text for End-to-End Application Tracing
* @param string $cid Client Identifier for End-to-End Application Tracing
* @throws \Exception
*/
public function __construct($module, $cid)
{
$this->conn = @oci_new_connect(O_USERNAME, O_PASSWORD, O_DATABASE, O_CHARSET);
if (!$this->conn) {
$m = oci_error();
throw new \Exception("Cannot open connection to Oracle db " . $m["message"]);
}
// Record the "name" of the web user, the client info and the module.
// These are used for end-to-end tracing in the DB.
oci_set_client_info($this->conn, CLIENT_INFO);
oci_set_module_name($this->conn, $module);
oci_set_client_identifier($this->conn, $cid);
}
/**
* Utiliza o recurso do Oracle que permite vincular informações do usuário da aplicação à sua sessão no banco de dados.
* @param type $userId
* @param type $userIP
* @param type $module
* @param type $action
*/
public function setUserInformation($userId, $userIP = null, $module = null, $action = null)
{
oci_set_client_identifier($this->dbh, $userId);
if ($userIP) {
oci_set_client_info($this->dbh, $userIP);
}
if ($module) {
oci_set_module_name($this->dbh, $module);
}
if ($action) {
oci_set_action($this->dbh, $action);
}
}
public function setModuleName($moduleName)
{
set_error_handler(static::getErrorHandler());
$isSuccess = oci_set_module_name($this->resource, $moduleName);
restore_error_handler();
return $isSuccess;
}
