If you target yourself with this spell, you must reveal your entire hand to the other players just as any other player would.

You name the card during Brain Pry’s resolution, then the player reveals their hand and discards if appropriate. There is no way for the player to do anything between you naming the card and the player discarding.