Re: calling one stored procedure from another

From: AFN (DELETEnewsgroupCAPSaccount_at_yahoo.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 20:15:12 GMT

thank you, but how do I "execute the stored procedure with the local
variables"? I don't know how to call a SP from another SP.

"
"Scott Morris" <bogus@bogus.com> wrote in message
news:OcNB1S6iEHA.704@TK2MSFTNGP12.phx.gbl...
> <snip>
> There is an example of using a cursor in BOL under "declare cursor". Just
> define a cursor with a select statement that selects the appropriate
> columns, fetch them into local variables, and then execute the stored
> procedure with the local variables.
>
> You can also search this NG for numerous examples of cursors - both good
and
> bad.
>
>

Relevant Pages

  • DBI Stored Procedures and Cursors
    ... I have a stored procedure that belongs within a package in Oracle. ... This is my first exposure to DBI, so I'm sure i'm doing something ... The stored procedure is supposed to initialize the cursor and all I ... I can execute without any problems, ...
    (perl.dbi.users)
  • Re: calling one stored procedure from another
    ... but how do I "execute the stored procedure with the local ... >> There is an example of using a cursor in BOL under "declare cursor". ... >> columns, fetch them into local variables, and then execute the stored ...
    (microsoft.public.sqlserver.programming)
  • Best Practices
    ... An important part of the conversion is moving a large number of Oracle stored procedure to VB.NET; the reason is that they containt too much business logic. ... define cursor 1 ... Should I execute the select statements at the beginning of the function, or should I execute them in the "middle" of the function? ... Do I use the same datareader for all the select statements (eg call ExecuteReader on the same datareader with different command object - or maybe the same command object with a different command string)? ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Can a cursor return rows from a stored procedure?
    ... > set nocount on ... > execute dbo.usp_proc1 ... >> I now want to call the same procedure within another stored procedure and ... Kind of like defining a cursor with a stored ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
Quantcast