I made a StoredProcedure to do an update on a table.:
ALTER PROCEDURE "CLIENTS"
"PURCHASE" DOUBLE PRECISION
set TOTAL = TOTAL + :PURCHASE
where CLIENT_CODE = :CODE;
Do I have to put a commit after the update or something ? Because when I execute the StoredProcedure from my application, then right after try to do an Edit on that table it gives me an Update Deadlock ! What´s wrong ??