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
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
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
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