aspose file tools*
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
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: 61766
    
  67

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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to increase the max size in where clause of update statement