oracle php ORA-00911 invalid character on UPDATE

Question

Hi Gurus

I'm running a PHP Script that updates a table from a Oracle DB. First I receive an object with JSON:

[{"lot":"KLMHA17N9N00","requestor":"B10078","id":"FRESHLOT","username":"B26696","password":"B26696"},{"lot":"KLMHA17R1800","requestor":"B10078","id":"FRESHLOT"}]

That with no problems since I've been using JSON in other projects.

Then I create the query after parsing the results to the $rmrid object:

$db_query = "update ao_lots 
                 set RMRID='".$rmrid->requestor."-".$rmrid->id."' 
               where ALOT_NUMBER='".$rmrid->lot."';";

If I echo the query I get this:

update ao_lots 
   set RMRID='B10078-FRESHLOT' 
 where ALOT_NUMBER='KLMHA17N9N00';

I don't see any problems here but when I execute the query I get this warning and nothing is updated:

WARNING: oci_execute() [function.oci-execute]: ORA-00911: invalid character

I did some search on that error code but I couldn't fix it with the info I found

Any suggestions would be greatly appreciated

Answer 1

The semi-colon isn't needed at the end of the SQL statement.

It is used by SQL*Plus and most other tools to indicate "I've finished writing the statement, now go execute it"