I assume it’s a private consultant you saw? Who recommended an investigation, and you have to pay for the investigation. Same as if s/he ordered a blood test.
€250 for initial consultation sounds about right. Hopefully follow up visits will be a bit less and hopefully your health insurance will cover at least some of the cost,
Check with your insurer that this consultant is covered as further procedures could be even more expensive
I think this may be in the wrong section, it’s not welfare and benefits