Passing multiple parameters for a parameter using temporary stored procedures 
Author Message
 Passing multiple parameters for a parameter using temporary stored procedures
Hi,

Instead of a list of dynamic parameters, what about one parameter, that
parameter being an array ?

Peter

Technical Architect / DBA
Pinnacle Insurance Ltd
Part time ruler of the galaxy (job share)

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!



Sun, 04 Jul 2004 00:09:43 GMT
 Passing multiple parameters for a parameter using temporary stored procedures

My guess is that your syntax is completely wrong.  Since you did not
post the stored procedure, I am guessing that this procedure has three
arguments, all of which are char or varchar.  I am also guessing that
the first argument is the value within the parentheses.  If so, the
correct syntax for doing this is:

execute ##test '(''NAE002'', ''AEC222'', ''DS98'')', 'DALLAS', 'NULL'

Based on your explanation I doubt that this example will work.  First,
the value of 'NULL' is concerning as this passes an actual string value
instead of a NULL string value.  Perhaps this is what you intended.  If
you are trying to use one or more of these arguments as part of an IN
clause, you will have to use dynamic SQL.  You cannot use something like

this ng, you will find lots of information about dynamic sql and
parameterizing an IN clause.

Quote:

> I am trying to pass multiple values for dynamic parameters
> using a temporary stored procedure.  I will use the "in"
> condition inside the stored procedure.  However, I can not
> able to pass in the values without an error message.

> Syntax:

> Execute ##test ('NAE002','AEC222','DS98'), 'DALLAS', 'NULL'

> Any suggestions?



Sun, 04 Jul 2004 01:25:52 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Passing Parameters down to a buried view or stored procedure using parameters

2. Passing Parameters to stored parameter queries using VB 5's Data Controls

3. temporary tables in stored procedures/parameter views vs stored procedures

4. Passing multiple null parameters to stored procedure

5. How to bind BLOB parameter of a stored procedure using Parameter Object of ADO

6. Passing parameters into stored procedure using Data Environment

7. How to pass datetime parameter to SQL7 Stored Procedure using VB

8. Passing parameters to a Stored Procedure using ADO

9. Passing parameters to stored procedure using Docmd.OutputTo

10. Pass Null to stored procedure parameter using ADO?

11. Pass Null to stored procedure parameter using ADO?

12. Pass Null to stored procedure parameter using ADO?


 
Powered by phpBB® Forum Software