/**
* @param $query
* @param $params
* @param $action
*/
public function execute($query, $action, $params = array())
{
$this->stid = oci_parse($this->conn, $query);
if ($this->prefetch >= 0) {
oci_set_prefetch($this->stid, $this->prefetch);
}
foreach ($params as $bv) {
oci_bind_by_name($this->stid, $bv[0], $bv[1], $bv[2]);
}
oci_set_action($this->conn, $action);
oci_execute($this->stid);
}
public function SetAction(string $action_name)
{
return @oci_set_action($this->conn_handle, $action_name);
}
/**
* 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 setAction($actionName)
{
set_error_handler(static::getErrorHandler());
$isSuccess = oci_set_action($this->resource, $actionName);
restore_error_handler();
return $isSuccess;
}