i have a stored procedure, in which i update a table based on date (inside a cursor). query seems like
update table1 set data1= "some value"
where date1 = T_date;
T_date is selected from the select query of the cursor. some times the T_date can be null and in that case am getting error
696: Variable (t_date) has undefined value.
Error in line 565
Near character position 43
is there any chance to handle this? please reply..