while (1=1)
BEGIN
  FETCH NEXT FROM my_cursor INTO @l_param_in;
  IF @@FETCH_STATUS != 0
      BREAK;
  exec ('call my_package.my_proc(?, ?)', @l_param_in, @l_param_out output) at OLED_DB_Oracle;
END;