Post reply

Nested Stored Procedures and Variables???

  • October 28, 2004 at 9:07 am

    #162504

    Hello,

    MSSQL 2000; TSQL

    I have a developer who has created a stored procedure (SP) which calls other stored procedures from within. He is getting a syntax error when he tries to pass a variable from the outter SP into the inner Sp's.  What is the life of a variable? Any thoughts? 

    Many thanks. Jeff

  • October 28, 2004 at 9:37 am

    #528320

    can you post the line where he is calling the other stored proc? its most likely a syntax error and nothing to do with variables..the variables have scope of the entire stored proc..i have called stored procs within storec procs and passed variables and no issues..

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

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

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