This belongs on [EMAIL PROTECTED] Send any followups to this there if you
want a response.
A separate session won't see the inserted row until you commit. It appears
you have AutoCommit off, so the commit doesn't occur until the program
exits.
--
Mac :})
** I may forward private database questions to the DBI mail lists. **
----- Original Message -----
From: "Ranjit Prabhu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 17, 2000 7:12 PM
Subject: DBD::Oracle --- help
> 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
