Strange Update SQL problem - DBD ERROR: OCIStmtExecute

[Sharma, Amit]

        Hi Again, 

        I think I did not completely described the problem. Please ignore my
last mail on it.

        I am trying to insert and update a record set in Oracle database.
Though the insert works perfectly fine, the update sql doesn't return back.
And when I try to interrupt the program by pressing CTRL+C, am getting the
following error: ORA-01013: user requested cancel of current operation (DBD
ERROR: OCIStmtExecute)


        Could anybody help me with this issue am facing. Here is main code
section pasted below.


        my $dbHandle = DBI->connect( 'dbi:Oracle:' . $DBName
                                  , $DBUser
                                  , $DBPassword
                                , { PrintError => 0, AutoCommit => 0 }
                                );

        $stmt="insert into add user_attribute values(\'testingamit\') where
domain=\'gome\' and name=\'henry\' and attribute_name=\'comment\'";


        my $go = $dbHandle->prepare($stmt);
        $go->execute();

        print "done insertion\n";

        print "Now Update \n";

        $stmt = "update user_attribute set attribute_value='testingamit'
where domain='gome' and name='henry' and attribute_name=\'comment'";

        my $go = $dbHandle->prepare($stmt);
        $go->execute || die "execute: $$stmt: $DBI::errstr";


        Thanx a lot,
        A.S.