when i execute the following SQL,there is an error occured:ORA-01037: maximum cursor memory exceeded
But when i reduce the number of IDEPARTMENTID,this SQL will run well. Whether there is a restrition of the number in IN(,,,) ?
select sum(IWORKHOURS) as totalworkhour,IBENEFICIALCUSTOMERCORPID,IBENEFICIALOFFICEID,IPROCESSORID,IPROCESSINGDEPARTMENTID,ITASKTYPEID,IWORKREASONID,IBENEFICIALOFFICEID AS IBENEFICIALOFFICEID1 FROM TBL_TSWS_WORKTIME WHERE IPROCESSINGDEPARTMENTID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,72,73,74,75,76,77,78,82,86,87,88,89,90,91,95,99,103,104,108,109,110,111,113,114,115,116,117,118,119,120,126,129,130,131,132,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,173,174,175,176,177,178) AND IPROCESSINGPRODUCTLINEID IN (1,2,3,4,5,6,12) AND ITASKTYPEID IN (129,128,127) AND IPROCESSINGMODEID IN (5,4) AND IBENEFICIALDEPARTMENTID IN (109,108) GROUP BY IBENEFICIALCUSTOMERCORPID,IBENEFICIALOFFICEID,IPROCESSORID,IPROCESSINGDEPARTMENTID,ITASKTYPEID,IWORKREASONID,IBENEFICIALOFFICEID
|