PHP ORACLE Warning: missing comma
 

Das ist mein php codeIch bekomme in der letzten Zeile (oci_execute) diesen Fehler: Warning: oci_execute() function.oci-execute ORA-00917 missing comma in s*****.php on line 130 (letzte Zeile). Ich habe schon stundenlang gegoogelt habe nichts gefunden.
Danke im voraus

Spontan würde ich sagen das die Bedingungsabfrage nicht geschlossen ist.

Da fehlt eine geschweifte Klammer

lösung:

$insert = "INSERT INTO T_LEIMBUCH (A_ID, A_LOGOTYPE, A_DATE, A_NOTE, A_ORDERNR, A_PRESSNO, A_BEAMNO, A_LAMELLANO, A_GLUEAMOUNTPRESENT, A_RATIOH1PRESENT,
A_RATIOH2PRESENT, A_TEMPERATUREPRESENT, A_LAMELLATEMPERATUREMIN, A_LAMELLATEMPERATUREMAX, A_LAMPTEMPUSEDCALCGAM, A_RATIOSET_MAX, A_RATIOSET_MIN,
A_FLGLUEAMOFFSET, A_GLUEAMOUNTSETVALUE, A_LINESPEED, AGLUEAMOUNTSETMAXPERBATCH, AGLUEAMOUNTSETMINPERBATCH, A_REMCATWHENLASTCAT, A_INPARAMETERPLANNEDCAT,
A_INPARESTCATLASTLAM, A_PRESSINGTIME_MINUTES, A_GLUEAMOUNTPREDICTEDSTART, A_GLUEAMOUNTPREDICTEDEND, A_PARAMETERBITS) VALUES (
:idleimbuch, :logotype, to_timestamp(:dateleimbuch, 'YYYY.MM.DD HH24-Mi-SS.ff3'), :noteleimbuch, :ordernr, :pressno, :beamno, :lamellano, :glueamountpresent,
:ratioh1present, :ratioh2present, :temperaturepresent, :lamellatemperaturmin, :lamellatemperaturmax, :lamptempusedcalcgam, :ratioset_max, :ratioset_min,
:flglueamoffset, :glueamountsetvalue, :linespeed, :glueamountset_maxperbatch, :glueamountset_minperbatch, :remcatwhenlastcat, :inparameterplannedcat,
:inparestcatlastlam, :pressingtimeminutes, :glueamountpredictedstartvalue, :glueamountpredictedendvalue, :parameterbits)";

$stmt1 = oci_parse($connect,$insert);
$arr_values_count = count($arr_values);

for($a = 0; $a < $arr_values_count; $a++) {
oci_bind_by_name($stmt1, ":idleimbuch", $arr_values[$a]['id']);
oci_bind_by_name($stmt1, ":logotype", $arr_values[$a]['LogoType']);
oci_bind_by_name($stmt1, ":dateleimbuch", $arr_values[$a]['Date']);
oci_bind_by_name($stmt1, ":noteleimbuch", $arr_values[$a]['Note']);
oci_bind_by_name($stmt1, ":ordernr", $arr_values[$a]['OrderNr']);
oci_bind_by_name($stmt1, ":pressno", $arr_values[$a]['PressNo']);
oci_bind_by_name($stmt1, ":beamno", $arr_values[$a]['BeamNo']);
oci_bind_by_name($stmt1, ":lamellano", $arr_values[$a]['LamellaNo']);
oci_bind_by_name($stmt1, ":glueamountpresent", $arr_values[$a]['GlueAmountpresent']);
oci_bind_by_name($stmt1, ":ratioh1present", $arr_values[$a]['RatioH1present']);
oci_bind_by_name($stmt1, ":ratioh2present", $arr_values[$a]['RatioH2present']);
oci_bind_by_name($stmt1, ":temperaturepresent", $arr_values[$a]['Temperaturepresent']);
oci_bind_by_name($stmt1, ":lamellatemperaturmin", $arr_values[$a]['Lamellatemperaturemin']);
oci_bind_by_name($stmt1, ":lamellatemperaturmax", $arr_values[$a]['Lamellatemperaturemax']);
oci_bind_by_name($stmt1, ":lamptempusedcalcgam", $arr_values[$a]['LamptempusedcalcGam']);
oci_bind_by_name($stmt1, ":ratioset_max", $arr_values[$a]['Ratioset_max']);
oci_bind_by_name($stmt1, ":ratioset_min", $arr_values[$a]['Ratioset_min']);
oci_bind_by_name($stmt1, ":flglueamoffset", $arr_values[$a]['Flglueamoffset']);
oci_bind_by_name($stmt1, ":glueamountsetvalue", $arr_values[$a]['Glueamountsetvalue']);
oci_bind_by_name($stmt1, ":linespeed", $arr_values[$a]['Linespeed']);
oci_bind_by_name($stmt1, ":glueamountset_maxperbatch", $arr_values[$a]['Glueamountset_maxperBatch']);
oci_bind_by_name($stmt1, ":glueamountset_minperbatch", $arr_values[$a]['Glueamountset_minperBatch']);
oci_bind_by_name($stmt1, ":remcatwhenlastcat", $arr_values[$a]['RemCATwhenlastcat']);
oci_bind_by_name($stmt1, ":inparameterplannedcat", $arr_values[$a]['Inparameterplannedcat']);
oci_bind_by_name($stmt1, ":inparestcatlastlam", $arr_values[$a]['InparEstCatlastlam']);
oci_bind_by_name($stmt1, ":pressingtimeminutes", $arr_values[$a]['Pressingtime-minutes']);
oci_bind_by_name($stmt1, ":glueamountpredictedstartvalue", $arr_values[$a]['Glueamountpredictedstartvalue']);
oci_bind_by_name($stmt1, ":glueamountpredictedendvalue", $arr_values[$a]['Glueamountpredictedendvalue']);
oci_bind_by_name($stmt1, ":parameterbits", $arr_values[$a]['Parameterbits']);

$stid = oci_parse($connect, $insert);
if ($stid == false) echo "Query-Error <BR>";
$error = oci_execute($stid);
if (!$error) {
$fehler = oci_error($stid);
echo "Oracle Fehler: ".htmlentities($fehler['message']);
die();
}
$result = oci_execute($stid); // don't autocommit!
if (!$result) break;
}
oci_free_statement($stid);
oci_close($connect);
oci_commit($connect);
fclose($datei);
unlink($_FILES['fileupload']['tmp_name']);