Re: Not all variables bound

[Sam Spritzer <SSpritzer@GW.CTG.COM>]

Ehhhh Kris....why do you always "challenge" us with hard questions???  I am 
wondering if SQR doesn't "know" Oracle placeholders so you may have to MOVE the 
value of :2 to a variable.
Sam

>>> KLove@MSA.COM 06/13 10:44 AM >>>
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