Not all variables bound

["Love, Kristin" <KLove@MSA.COM>]

OK, sorry guys.
In this case I'm just stupid.

One part of my UNION had
where dh.cal_id= #filter_cal_id

the other part of my Union had
where dh.cal_id=:2

Can anyone guess what's wrong here???? Oops. Too much cut & paste from SQL
station.

Yes, Sam, I tried using the -s parameter to show the SQL when the problem
first occurred (is that what you meant by a TRACE? because you wouldn't get
a real ORACLE trace if the program doesn't actually execute, would you?).
But when it parsed, both statements look like this:
where dh.cal_id=:2

So that wasn't much help.

The only thing that saved me was that I had hard coded another of the
substitution variables, and I noticed while I was looking at my parse (wait
a minute, should that really always be 1? I thought it should be :1). So
when I went back to that part of the union, I noticed that the second
substitution variable was still the ORACLE placeholder (:2) instead of the
variable name (#filter_cal_id).

:) Kristin