Ejemplos de OciExecute en PHP

Ejemplo n.º 1

Archivo: database.inc.php Proyecto: SoftScape/opensis

function db_trans_query($connection, $sql)
{
    global $DatabaseType;
    if ($DatabaseType == 'oracle') {
        $parse = ociparse($connection, $sql);
        if ($parse === false) {
            db_trans_rollback($connection);
            db_show_error($sql, "DB Transaction Parse Failed.");
        }
        $result = OciExecute($parse, OCI_DEFAULT);
        if ($result === false) {
            db_trans_rollback($connection);
            db_show_error($sql, "DB Transaction Execute Failed.");
        }
        $result = $parse;
    } elseif ($DatabaseType == 'postgres') {
        $sql = ereg_replace("([,\\(=])[\r\n\t ]*''", '\\1NULL', $sql);
        $result = pg_query($connection, $sql);
        if ($result === false) {
            db_trans_rollback($connection);
            db_show_error($sql, "DB Transaction Execute Failed.");
        }
    }
    return $result;
}

Ejemplo n.º 2

Archivo: database.inc.php Proyecto: linil/centreSIS

function db_trans_query($connection, $sql)
{
    global $DatabaseType;
    // TRANSLATION: do NOT translate these since error messages need to stay in English for technical support
    if ($DatabaseType == 'oracle') {
        $parse = ociparse($connection, $sql);
        if ($parse === false) {
            db_trans_rollback($connection);
            db_show_error($sql, "DB Transaction Parse Failed.");
        }
        $result = OciExecute($parse, OCI_DEFAULT);
        if ($result === false) {
            db_trans_rollback($connection);
            db_show_error($sql, "DB Transaction Execute Failed.");
        }
        $result = $parse;
    } elseif ($DatabaseType == 'postgres') {
        $sql = preg_replace("/([,\\(=])[\r\n\t ]*''/", '\\1NULL', $sql);
        $result = pg_query($connection, $sql);
        if ($result === false) {
            db_trans_rollback($connection);
            db_show_error($sql, "DB Transaction Execute Failed.");
        }
    }
    return $result;
}