Calling Stored Procedure that calls Stored Procedure in ASP 
Author Message
 Calling Stored Procedure that calls Stored Procedure in ASP

I call a stored procedure from ASP and do not have a problem.  When I call
a stored procedure that calls another one I receive no record set back in
my asp.  Has anyone experienced this.  My two stored procedures are
included below.

**************************************************
SP Number One
*************************************************
CREATE PROCEDURE up_getPubPartList


AS







  DECLARE cuParts CURSOR FOR
    SELECT DISTINCT UnitCPN
      FROM PubUnit

      ORDER BY UnitCPN
    FOR READ ONLY

  OPEN cuParts



  BEGIN

    BEGIN



      ELSE



    END


  END

  CLOSE cuParts

  DEALLOCATE cuParts


**************************************************
SP Number Two
*************************************************
CREATE PROCEDURE up_getPubPartListPerUnit



AS









4)


  DECLARE cuStatus CURSOR FOR
    SELECT Status
      FROM PubUnit

      ORDER BY Status
    FOR READ ONLY

  OPEN cuStatus



  BEGIN

    BEGIN


        BEGIN

            BEGIN


              ELSE
                BEGIN





                    BEGIN


                      ELSE

                    END
                  ELSE




                END
            END
          ELSE
            BEGIN



            END
        END
      ELSE
        BEGIN

            BEGIN






              ELSE




            END

          ELSE
            BEGIN




            END
        END
    END


  END


  BEGIN


    ELSE
      BEGIN





          BEGIN


            ELSE

          END
        ELSE




      END
  END

  CLOSE cuStatus
  DEALLOCATE cuStatus



Tue, 30 May 2000 03:00:00 GMT
 Calling Stored Procedure that calls Stored Procedure in ASP

Do you get a result set when you run this in ISQL/W?
--
Bob Pfeiff, MCSD
Spectrum Technology Group, Inc.

<<remove "nospam" to reply via e-mail>>



Wed, 31 May 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Calling a Java Stored Procedure from another Java Stored Stored Procedure

2. Stored procedures calling stored procedures

3. Stored Procedure calling a Stored Procedure

4. Stored Procedure that calls multiple stored procedures

5. QUESTION: How can I call a Stored Procedure from another Stored Procedure

6. Calling extended stored procedure from stored procedure

7. Stored Procedure calling Stored Procedure

8. HELP: Stored procedure calling stored procedure

9. Calling a Stored Procedure from a Stored Procedure

10. Calling a stored procedure with parameters from another stored procedure

11. Stored procedures calling stored procedures....

12. Calling a stored procedure within a stored procedure.


 
Powered by phpBB® Forum Software