Hi Gurus,
While executing a large query (400 k) thru application i am getting a error -
java.sql.SQLException: The server encountered a stack overflow during compile time. Severity 18, State 1, Procedure 'OCI_IL_BA_18NT null', Line 1
Pl. note that query contains a big IN clause with more then 1000 IN parameters.I dont want to resize the query but increase the stack space of sql server 2000 compiler to accomodate big sized query during compiling.Pl. anybody tell me how can we change/increase the stack space size.
TIA
Sheilesh