I have found that after the Update to SP3 I have a wierd problem..

Occasionally some of my Updates freeze the application.
This one always does it:
UPDATE "ARTISUP" SET "ARTIKEY"=?var1,"SUPNAME"=?var2,"SUPNO"=?var3,"SUPART"=?var4,"SUPCOLOR"=?var5,"COUNTRYF"=?var6,"COUNTRYG"=?var7,"LTDAYSF"=?var8,"LTDAYSG"=?var9,"ATPRICE"=?var10,"ATPRICEO"=?var11,"ATPRICEC"=?var12,"ACTIVESUP"=?var13,"LASTEDIT1"=?var14,"LASTEDIT2"=?var15
WHERE recno = 2

From a SQLEXEC() on this above statement..
I can see on my Oracle 8.0.5 server that:

select username,sql_text
from v$session a, v$sqlarea b
where a.sql_address = b.address
and a.status = 'ACTIVE';

Shows my SQL as active but it never returns from it I have to kill the app.

If I run the update from SQLPLus it works.

I have restarted the machine.. and server and there is no locks on the table...

I just don't know! Any ideas...