Post reply

Strange st proc behavior

  • September 12, 2002 at 9:43 am

    #158310

    Hi all,

    I have a strange issue in one st proc that I'll call "master". This procedure makes calls to other 5 st procs. The "master" makes the 5 calls always in the same way. The other st procs are called like this "INSERT INTO #TempTable EXEC STOREDPROCEDURE @PARAM1, @PARAM2, @PARAM3". When this call is made I get 2 type of errors, one telling me that the number of supplied columns differ from the table structure and the other telling me that the column name "xpto" is invalid. Until here ok, it's easy to track, but these errors just finish if prior to the master proc call I execute each one of the 5 procedures stand-alone and only then call the master. If I make this way, everything works properly. Someone can please tell me what is this? Thanks in advance for all!

  • September 12, 2002 at 3:05 pm

    #436435

    Just make sure other procedures (5 procs) should not be returning more than the expected number of clumns and they should be returning only one recordset otherwise behavor is unexpected as you are facing currently. "xpto" might be an extra column returned bye one of the procs. These kind of errors are mostly scenario based problems.

    Good luck.

  • September 13, 2002 at 1:30 am

    #436463

    I think ur problem is related to this link....

    http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4653&FORUM_ID=65&CAT_ID=1&Topic_Title=Strange+behaviour%2E%2E%2E%2E%2E&Forum_Title=Performance+Tuning

    Prakash

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

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

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