Get your CodeRanch badge!*
The moose likes JDBC and the fly likes how to increase the max size in where clause of update statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to increase the max size in where clause of update statement" Watch "how to increase the max size in where clause of update statement" New topic
Author

how to increase the max size in where clause of update statement

A Chauhan
Greenhorn

Joined: Nov 21, 2006
Posts: 15
Hi All,

Can somebody please through a light on how to increase the max size of statement in where clause of update statement in oracle. I am facing this problem as the data that is to be compared exceeds the max size so sql ignore the full update statement and no result is generated.

for example

select molregno from assay_detail where assay='Percentage inhibition of unphosphorylated VEGFR2 kinase activity studied using 5-40nM human VEGFR2delta50 expressed in baculovirus/insect cells, 20mM poly(Glu-Tyr)4:1, 3mM ATP, sffsdfsfsdftty, fhgfhuikikf, 50U/ml lactate dehydrogenase, 20U/ml pyruvate kinase, 8990kgkgkkgkgll ghjgjhjghjgerfretegnnf tgh gggggby measuring the absorbance at 340nm on Beckman spectrophotometer by coupled spectrophotometric assay';
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60050
    
  65

Please take the time to choose the correct forum for your posts. This forum is for questions on HTML and Javascript.

This post has been moved to a more appropriate forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: how to increase the max size in where clause of update statement
 
Similar Threads
Data Update
Update resturns zero rows updated without throwing errors.
update where clause
How to increase the max size for 'where' clause in update statement in oracle
JDBC-3 Design Question