At 03:25 PM 27/11/2003 +0100, you wrote:

> >>No. You should get an exception in the first case and the PSQL in the
> >>second case should fail to compile. rdb$procedures doesn't have a column
> >>called rdb$procedures.
>
> >>Is your problem description correct?
>
> >>heLen
>
>
>I have to correct myself (to many windows opened :-)
>
>if i do
> select count(*) from rdb$procedures rp where rp.rdb$procedure_name =
> :oime_procedure
>then the result is correct
>
>if i do
> if (exists(select * from rdb$procedures rp where rp.rdb$procedure_name =
> :oime_procedure)) then ...
>the result is always true

What is the problem?

heLen