Post reply

Stack overflow during compile in a big IN query

  • April 7, 2003 at 5:32 am

    #159084

    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

  • April 7, 2003 at 10:58 am

    #453368

    I would try putting the values of your in clause into a temp table or static parm table, then join to that vs. having such a big "in" clause. That way it's also more flexible for future change.


    Darren

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply