Oracle Server side - common error ?

ThalesPereira

It seens to be a lot of posts around this but i wasn't able to find a proper solution for this.

Using the default script provided, when i try to execute the php_oracle.php ( content of the file is : http://www.datatables.net/development/server-side/php_oracle )

I receive de rerror:

[quote]
Warning: oci_bind_by_name() [function.oci-bind-by-name]: ORA-01036: illegal variable name/number in D:\Program Files\xampp\htdocs\cmportal\tests\datatable\scripts\php_oracle.php on line 233

Warning: oci_bind_by_name() [function.oci-bind-by-name]: ORA-01036: illegal variable name/number in D:\Program Files\xampp\htdocs\cmportal\tests\datatable\scripts\php_oracle.php on line 234

Warning: oci_execute() [function.oci-execute]: ORA-30485: missing ORDER BY expression in the window specification in D:\Program Files\xampp\htdocs\cmportal\tests\datatable\scripts\php_oracle.php on line 260

Warning: oci_fetch_array() [function.oci-fetch-array]: ORA-24374: define not done before fetch or execute and fetch in D:\Program Files\xampp\htdocs\cmportal\tests\datatable\scripts\php_oracle.php on line 262

Warning: oci_execute() [function.oci-execute]: ORA-30485: missing ORDER BY expression in the window specification in D:\Program Files\xampp\htdocs\cmportal\tests\datatable\scripts\php_oracle.php on line 281

Warning: oci_fetch_array() [function.oci-fetch-array]: ORA-24374: define not done before fetch or execute and fetch in D:\Program Files\xampp\htdocs\cmportal\tests\datatable\scripts\php_oracle.php on line 284
{"sEcho":0,"iTotalRecords":"163","iTotalDisplayRecords":0,"aaData":[]}

[/quote]

Im new to php and datatables, so it would be great to have a practical example =)

ThalesPereira

daily bump for this.

dthunsterblich

Hey ThalesPereira !

I'm also using this script and having some trouble with it.

Is the script working in the default configuration? It works for me without an error if I don't do a search. If I run a search it’ll break... and I get similar Error expressions.
Could you provide the PHP script initialization code?

I suppressed the error for doing a search and it works perfectly. It is not a good solution! I'm still on it...

Best wishes

dthunsterblich

I think I fixed my Problem.

The script has oci_bind_by_name() prepared, but it seems like it is never used for column filtering. You need to insert the variable :whereParam that should do the trick

ThalesPereira

Thank you for the replyi will try to make a test asap to check it out =)

rromulos

I have the same problem here, somebody found a solution? Thales worked fine to you?

rromulos

I created a new statement for this and changed $statmntFinal for my own $statement, even after this I got some warnings for that I put error_reporting(0);

now almost everything are working properly, with exception bServerSide where the message "Processing..." is getting stuck. Trying find out whats causing this problem I inserted some logs (using a php class) to help me on this task and on this way was possoble to found that the json return is ok, even if i'm doing a search, but the datatable keep the message stuck without refresh data, somebody got this problem?