DBD::Oracle --- help

[Ranjit Prabhu]

I'm having trouble binding values to a statement handler.
$dbh=DBI->connect....
$csr = $dbh->prepare(q{
     BEGIN
             PACKAGE_NAME.PROCEDURE_NAME
                        (
                           :val1,
                           :val2,
                           :val3,
                           :val4,
                           :val5,
                           ....
                           ....
                           ....
                          );
     END;
});

$csr->bind_param(":val1", $val1);
$csr->bind_param(":val2", $val2);
$csr->bind_param(":val3", $val3);
$csr->bind_param(":val4", $val4);

eval { $dbiRetVal = $csr->execute() };

.....

$dbiRetVal has value 1 after transaction - for success
$DBI::errstr is empty - confirming grand success

but, when i connect to the database and check the tables, I get no such
rows with values that should have been inserted.

Curiously, when i try and do a reload on my page, i.e., call the cgi
again with same values, i get :-
$dbiRetVal has no value - for failure
$DBI::errstr is loaded with "ora unique constraint violations" -
confirming grand failure and implying that this data was inserted 1st
time round.


what is going on ?????

thanx,
ranjit