Procreate has not announced a limit. There is an option to set your duration in hours, so its seems like pretty long! I think the biggest factor will be the storage on your iPad, and it being able to hold the size of your file.