I'm running a PHP script that updates a table from an Oracle DB instance.
First, I receive an object with JSON:
[{
"lot": "KLMHA17N9N00",
"requestor": "B10078",
"id": "FRESHLOT",
"username": "B26696",
"password": "B26696"
}, {
"lot": "KLMHA17R1800",
"requestor": "B10078",
"id": "FRESHLOT"
}]
(This JSON is known to have no problems, since I've been using this 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=开发者_如何学JAVA'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 searching on that error code, but I couldn't fix it with the info that I found.
Any suggestions would be greatly appreciated.
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"
精彩评论