M
MarkD
It's a simple update query, and I have copied the SQL
string and ran it in SQL*Plus and the query updates in
seconds. So, I know the query itself isn't the problem.
The driver and connection doesn't seem to the problem
either as I use the same connection for select p-t queries
and it runs fine.
The query (in case I'm wrong and it is a query issue):
UPDATE PSA SET PSA.TRACK = 0 where N_CODE in (select
n_code from PSA_FOUND)
string and ran it in SQL*Plus and the query updates in
seconds. So, I know the query itself isn't the problem.
The driver and connection doesn't seem to the problem
either as I use the same connection for select p-t queries
and it runs fine.
The query (in case I'm wrong and it is a query issue):
UPDATE PSA SET PSA.TRACK = 0 where N_CODE in (select
n_code from PSA_FOUND)