Leonardo Cosmai wrote:

> Sorry for the delay...
>
> This is the statement:
>
> SELECT A.* FROM A INNER JOIN A_STORE_PROCEDURE(?,?) B ON (A.COL1 = B.COL1)
>
> where A_STORE_PROCEDURE is really a simple FOR SELECT.....
>
> Thanx
> Ciao
> L.
>

Leo,

Use "left join" instead of "inner join" to join with procedures.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br