I have a question along the same line as this one. Here is my scenario:
I have 3 stored procedures: spA, spB, and spC. Each of the procedures
accept multiple parameters.
In any given set of calls, spA will only execute once. spB and spC can
execute multiple times, and not always the same number of times.
Also, I need these to execute as a transaction, but without the use of MTS.
So my setup is something like:
create procedure spZZ (parameters ...)
-- Parse the parameters
sp_execute (spA & parameters1)
sp_execute (spB & parameters2)
sp_execute (spB & parameters3)
sp_execute (spB & parameters4)
sp_execute (spC & parameters5)
sp_execute (spC & parameters6)
I know I can pass all the parameters for all procedures into spZZ. My
question is: is this the best solution given my limitations?
>>This does not work for some reason :(
>>if I call (from Quary Analyzer)
>>pGetData sProcName, iProcPara with your 2nd example
>>I get the following
>>Could not find stored procedure 'm'.
>>seems like it is not reading the entire stored proc name
>>thanks a bunch,
> Sorry did not notice you didn't have a size on your varchar parameter in
> which case it defaults to 1 character.
> William D. Bartholomew