[PROBLEM] Oracle Server Side Processing

rromulos

Hello everybody,

The last days i'm trying to use data tables with Oracle server side processing, but i'm getting error on oci_bind_by_name(): below follows the warning message.

Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number in ...

Remembering that i'm getting this message two times.

This message is referent for this line:
oci_bind_by_name($statmntFinal, ':iDisplayStart', $dsplyStart);

and also this line:
oci_bind_by_name($statmntFinal, ':iDisplayEnd', $dsplyRange);

of course due this i'm getting another errors.

The Json return print this:
{"sEcho":0,"iTotalRecords":"3","iTotalDisplayRecords":"3","aaData":[[null,null],[null,null],[null,null]]}

in another words due the problem with these two lines my "aadata" is getting null

Someone could please help me on this issue?

Maybe someone else had these error on the past and can give me some way to solve that.

I'm using this code as reference:

http://www.datatables.net/development/server-side/php_oracle

and I have oracle 11g Express Edition version.

Thanks a lot.

MarcioRM

Hi,

I have the same problem using the same Oracle version.