Problems with transactions codeigniter

0

my doubt is that I am executing the following code in codeigniter, it consists of executing the procedure in the SQLServer that returns a value (output), but in codeigniter I always get this error message:

$data = array(
            $this->input->post("CodcliRemitente"),
            $this->input->post("CodcliBeneficiario"),
            $this->input->post("slcSucursalEntrada"),
            $this->input->post("slcSucursal"),
            $this->input->post("idImporte"),
            $this->input->post("idComision"),
            "0.00",
            "0.00",
            "1",
            $this->input->post("txtSerie"),
            $this->input->post("txtCorrelativo"),
            $this->input->post("tipoComprobante"),
            $this->session->userdata("IDEmpleado"),
            $this->input->post("txtMensaje"),
            $this->input->post("txtEncargado"),
            $this->input->post("inter"),
            $this->input->post("lblNAT"),
            "-",
            "004",
            "-"
        );
    $this->db->trans_start();

    $this->db->query("SET NOCOUNT ON");
    $this->db->query("DECLARE @respuesta INT");
    $this->db->query("EXEC sp_regEnvioGiroRecepcionista_Recepcionista_1 ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, @respuesta = @respuesta OUTPUT",$data);
    $query = $this->db->query("SELECT @respuesta as N'@respuesta'");

    $this->db->trans_complete();


    var_dump($query->row_array());
    
asked by mty95 12.02.2018 в 21:51
source

0 answers