If Oda decides that something like that exists, than he has to counter-balance it, like he did with the "normal" devilfruits.
So the fish who ate it, can't go outside of the water or he'll be unable to move.
Which would be rather pointless.
Because the story is about the strawhats.
Ruffy can't fight someone who can't get of out the water and he himself can't fight in the water.
But who knwos. Oda could make it happen if he wants (hope he doesn't though)