This stuff is plastic, & waterproof. Never tried it, but it could probably take YEARS immersed in water. It might be covered with algae, but still useable.

The green stuff sounds like some kind of epoxy or polymer/epoxy. I've always had trouble mixing it properly.