A bit of background: I'm working with a table that is pumped over from Lotus Notes, there is a bug in LEI where Null Strings do not transfer as null, but as \0 (or rather a null terminator, or char(0)). Thus before working on certain tables, I make sure to convert fix the nulls.
A sample update statement:
UPDATE oracle2.SRESTITUTION set FINDICT_COUNT = NULL WHERE FINDICT_COUNT = chr(0)
My PL/SQL knowledge is limited, thus I'm using a separate statement to find the columns:
select COLUMN_NAME from all_tab_cols where TABLE_NAME = '" + table + "' and DATA_TYPE = 'VARCHAR2'
Thus once I have the columns, I run the updates over them. It seems to work fine on the first one or two, then it seems to freeze at the others.
If I try the statement in Toad, they seem to work. The table has about 33000 records.
If I did not have the .setTimeout the querry would run at no end, left it for several hours just to see, nothing ever came back.