Using EXEC in select stored procedure

• Mark Smith-331976

  SSC Journeyman

  Points: 84

  More actions

  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.

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  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"