Re: how to pass parameters dynamically [message #37094] |
Thu, 17 January 2002 03:22 |
Nina
Messages: 113 Registered: March 2000
|
Senior Member |
|
|
Satish,
Thank you for the response. I am not preparing sql statement inside procedure. I am trying to find a way to substitute the second parameter passed to this procedure for something like, DATE, OR any opther variable name. But I want to give this variable a value, depending on what cursor fetches. So if my cursor fetches something like, emplouyee_number = 1, then I will make DATE = effective_date. But if cursor fetches something like, employee_number = 2, then I want to make DATE = not_effective_date. I thibk I am just missing the syntax.
Or do you think it is possible, depending on what cursor fetches, to either not change the value of the second passed to the procedure parameter, or make it -->
effective_date = not_effective_date
Thank you a lot for your response.
|
|
|