thank you everybody so much for your input, I will try your ideas, and hopefully they will work

I did, but it doesn't help me at all. That is why I wanted to elaborate. So basically I can't do anything. Also, you can't put limit values by other prompts if a prompt is generated by SQL which it is in my case. So, no... that didn't help. And the prompts are divided, two different prompts, they were not created in the…

bump

I thought, obviously wrong, the only way for someone replying was raising a couple of red flags. I stand by what I said but not by the way I said it. Oracle user support is disastrous. Sorry if I have mistaken you for an official support forum, but come one, community.oracle.com kinda looks like it's official. I really…

my terrible childish rantings that I have edited