Oracle oci error

jpavan

Hi Allan!.
I'm connected to an Oracle database with oci8 and it works fine with an application built with Zend.
However, when I try to read data from a table with DataTables it gives an error: "Error executing SQL for data get.Enable SQL debug using-> debug (true)".
Using your debugger I get in Tables, Last JSON from server the following:

{
    "fieldErrors": [],
    "error": "Error executing SQL for data get. Enable SQL debug using `->debug(true)`",
    "data": [],
    "ipOpts": [],
    "cancelled": [],
    "debugSql": [{
        "query": "SELECT  COUNT(v_tablas.nomtab) as \"cnt\" FROM  v_tablas WHERE v_tablas.rol = :where_0 AND v_tablas.permiso > :where_1 ",
        "bindings": [{
            "name": ":where_0",
            "value": "5",
            "type": null
        }, {
            "name": ":where_1",
            "value": 0,
            "type": null
        }]
    }, {
        "query": "SELECT  COUNT(v_tablas.nomtab) as \"cnt\" FROM  v_tablas WHERE v_tablas.rol = :where_0 AND v_tablas.permiso > :where_1 ",
        "bindings": [{
            "name": ":where_0",
            "value": "5",
            "type": null
        }, {
            "name": ":where_1",
            "value": 0,
            "type": null
        }]
    }, {
        "query": "SELECT  v_tablas.nomtab as \"v_tablas.nomtab\", v_tablas.destab as \"v_tablas.destab\", v_tablas.rol as \"v_tablas.rol\", v_tablas.codpct as \"v_tablas.codpct\", v_tablas.permiso as \"v_tablas.permiso\", v_tablas.retaut as \"v_tablas.retaut\" FROM  v_tablas WHERE v_tablas.rol = :where_0 AND v_tablas.permiso > :where_1  ORDER BY v_tablas.destab  asc  LIMIT 17",
        "bindings": [{
            "name": ":where_0",
            "value": "5",
            "type": null
        }, {
            "name": ":where_1",
            "value": 0,
            "type": null
        }]
    }]
}__

Could you help me pls?

Regards,
jorge.

allan

Hi Jorge,

This is with server-side processing isn't it? What version of Oracle is it you are using? I have a fix that will work for 12c or newer, but older versions of Oracle don't support FETCH NEXT and OFFSET, which the Editor libraries require to be able to do server-side processing.

Allan

jpavan

Hi Allan.

I was able to solve the problem commented the ajax line:
type: 'POST'

Regards,
jorge.