Re: Parameter Query in Oracle?

HI Paul,

If I run this:

SELECT *
FROM Place
WHERE Place_Type = :parPlaceType
or :parPlaceType is null

Iget this message:

"Not all variables bound"

What does that mean?
How can I enter a value for this parameter?

Thanks,

Edgar
Paul Dorsey wrote in message ...
>Edgar,
>First you are asking in the wrong place, this really is an access question.
>There is no such thing as a parameterized view in Oracle.
>
>However, this might help.
>
>If the query you pass is
>
>SELECT *
>FROM Places
>WHERE Place_Type = :parPlaceType
>or :parPlaceType is null
>
>then that should take care of you.
>This assumes that you can handle a bind variable in Access.
Received on Thu Aug 26 1999 - 00:00:00 CEST