Very Computer

I would like to do something like this

GO

Is that doable?

In case the above makes no sense here is what I want
- i want to pass a string and int to a stored proc
- string is a another stored proc name
- int is a stored proc param

so if I do
pGetData pGetText, 10

i want it to execute
pGetText 10

thanks bunch,
branka

Beware though... don't forget that the caller can call any stored procedure
that is capable of taking a single int as a parameter... And if I remember
my SQL security correctly it runs with the permission of the person that
created the stored procedure. So this probably isn't a good idea. You can
make it minimally safer by forcing some kind of prefix to the stored
procedure name. The second example shows this.

CREATE PROCEDURE pGetData


AS
SET NOCOUNT ON

GO

CREATE PROCEDURE pGetData


AS
SET NOCOUNT ON

GO

Regards,

William D. Bartholomew

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
or something.

thanks a bunch,
branka

any stored procedure

Quote:> 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
> or something.

> thanks a bunch,
> branka

Sorry did not notice you didn't have a size on your varchar parameter in
which case it defaults to 1 character.

Regards,

William D. Bartholomew

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 ...)
AS

-- Parse the parameters

begin tran
sp_execute (spA & parameters1)
sp_execute (spB & parameters2)
sp_execute (spB & parameters3)
sp_execute (spB & parameters4)
sp_execute (spC & parameters5)
sp_execute (spC & parameters6)
commit tran
GO

I know I can pass all the parameters for all procedures into spZZ.  My
question is: is this the best solution given my limitations?

Thanks,
Jonathan