Toad World® Forums

Skip Bind Variable

I am using the SQL Editor in TOAD Data point (not the Query Builder), and I have 3 Bind Variables, one of which I want to have the option to ignore when running the query. I've tried deselecting it, as well as changing the 'direction' to be either OUT or RETURN, which should skip the bind variable, but it will only skip that variable if I comment it out of the actual SQL code, which isn't optimal. I must be missing something rather simple, but I cannot seem to find it.