Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    19

    Question Unanswered: Calling SP Inside the SP

    hai guys

    how should we have to cal the store procedure inside the same store procedure.

    for Example

    Create procedure A
    as
    Begin
    Select * from mytable
    execute A
    end.

    is this the correct one

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    yes that is correct.
    but the level of nesting is 32 if u exceed this u will get this error:
    "Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)."

  3. #3
    Join Date
    Jun 2004
    Posts
    19
    Got an error object does not exists, while compiling. how to compile

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    can u post the actual script ur using?
    and does the table u r trying to access, exist in the database???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •