Subject Re: [ib-support] Distinct with stored procedure
Author Ivan Prenosil
> From: Ajay <ajayb@...>
> I am using a Select statement with a Distinct Clause, the query works fine but when i use a stored
procedure in the Select it returns an Error .
> For Eg
> Select Distinct ID,First_Name,(Select Cont From GetIDs)
> From Contacts
>
> Error :- Invalid request BLR at offset 303
> context already in use (BLR error)

It is known (and old) bug.
You can't mix DISTINCT and Subquery in SELECT clause.

Ivan
http://www.volny.cz/iprenosil/interbase