Oracle: Inserts fail...

Der_Fisch

Hi all,
i have a huge problem...
i want to insert data from a form into an oracle db table.
eveythings correct, but there seems to be a multiple insert of the same data! which isn't possible because of the primary key so i get the Error

ORA-00001: unique constraint (######.SYS_C00773) violated

the dataset is there when i select, but i have absolutly no idea why this error occurs...

heres my code

<?php
     $spe = strtr($_POST['spesen'], ",", ".");
     $kurs = strtr($_POST['kurs'], ",", ".");

 $query1 = "insert into mont_staaten values(" . $_POST['nummer'] . ",'" . $_POST['name'] . "', " . $spe . ", " . $kurs . ", '" . $_POST['currency'] . "')";

 echo $query1;

 include "db_connect.php";
 include "error_report.php";

     $insrt = OCIParse($db, $query1);
     OCIExecute($insrt,OCI_DEFAULT);
     Error_Report($insrt);
     OCICommit($db);
?>

hope that you see the error and can help me... i'm completly stuck... 🙁

Der_Fisch

ohh, c'mon...
isn't there somebody who has an idea?

is it so completly unusual to work with php an oracle instead of mysql? 😕

jernhenrik

Which is your primary key? What does your database table mont_staaten layout look like? Do you have any unique'ed columns?

Der_Fisch

MONT_Sttaten
S_ID		[number(3)] {PK}
S_Name	[varchar2(50)]
S_Spesensatz	[number(3)]
S_Tash_Kurs	[number(12,10)]
S_Currency	[varchar2(10)]

thats the table.. as you see, S_ID is primary key (and has the primary key constraint)...
and there are NO unique cloumns or other constraints...
hope that clears the question 🙂

Der_Fisch

up...
there must be an answer for this... i really hate that msg by now... :mad:

Castle

looks like your sql is missing somthing...

INSERT INTO table_name (cola, colb, colc) VALUES (x,y,z);

looks like you are not defining your where your values go.

Der_Fisch

nope.
this is correct. try this directly on a database and you'll see that this is correct.
what you meant is only necessary when you insert not into all columns or when you insert in an different order.

but thanks, i hope that there will be an answer for this soon.

Castle

the way I understand and have found with oracle is that if you leave out that optional part you must do the insert in the order the items were created in the db. and if you wish to follow ansi standards (at least the last time I checked) you should include this.