Re: Not all variables bound

["Arosemena, Efrain" <Earosem@TOYOTARP.COM>]

Sorry for my english...

In some case the datatype isn't compatible.

-----Mensaje original-----
De: Love, Kristin [mailto:KLove@MSA.COM]
Enviado el: Tuesday, June 13, 2000 9:44 AM
Para: SQR-USERS@list.iex.net
Asunto: Not all variables bound


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