Re: Oracle Hints

[richard.mitchell@GSA.GOV]

Mark,

This may have been mentioned previously but I don't have the thread.

When I use substitution variables, I often get lost in the detail of what
is getting sent in the Select. What I do is add a capital X to the end of
the Select to see how SQR is putting it together. Usually I get ......where
LOCATION = :1 X    when I actually want .....where LOCATION = 'MY LOCATION'
X  which means I left the [  ] off the substitution variable again. I put
the [ ] in again and run the program with the X on the end until I see the
Select I want, then remove it to run the code.

Sure would be nice if SQR would give a 'debug' option to view the Select.
Hint, hint...

Hope this helps,

Rick


--------------------------------- Reply -------------------------------

Folks,

Thanks for all your responses.  Seems that the problem that I am
experiencing is related to SQR having problems with using substitution
variables in the FROM part of a BEGIN-SELECT statement.  They just
vapourize !!!   This in turn has caused the statement to be incorrectly
formatted

Regards

Mark Pietersz