I am very sorry you are in so much pain.
I had my discogram twice and both times I had severe pain for at least couple weeks. I am talking pain; I couldn't sleep, I was not able to lay on my back at all. I was increasing PK since couldn't stand the pain.
Yes, it is very painful and it lasts for a while.
My dr told me that more damage you have in your back - more pain will be after discogram since they irritate those levels to confirm what exactly is your problem. And worse condition they are - more pain you experience.
My girlfried had discogram done and had no pain at all! After procedure her DR sent her to gynecologist saying that pain she experience come from different areas but not her back. He back was perfect and that is why she had no pain.
Have a better day tomorrow!!!!