Post reply

Using EXEC in select stored procedure

  • September 21, 2006 at 2:36 am

    #170431

    Hi

    I need to execute an existing stored procedure (using EXEC) in another stored procedure before returning a recordset via a select statement -

     

    CREATE Procedure TEST AS

    BEGIN

       EXEC Proc 1

       SELECT Field FROM Table

    END

    I'm getting Error 3001 (Application-defined or object-defined error)

    Can I do this? (I can in Oracle)

     

    Thanks

    Mark.

  • September 21, 2006 at 2:54 am

    #661664

    hi

    u shud be able to do what u r trying, but r u trying to select data from a temp table created inside the inner procedure(proc 1) that u r trying to execute

     

    "Keep Trying"

    "Keep Trying"

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

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