Home » SQL & PL/SQL » SQL & PL/SQL » Re: how to pass parameters dynamically
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.
Previous Topic: using sequence in default clause for a column
Next Topic: FOREINKEY CONSTRAINT'S REFERENCE TABLE INFORMATION
Goto Forum:
  


Current Time: Tue Aug 11 08:48:03 CDT 2020