> Shouldn't this work with the new derived tables feature?
>
> select n.*
> , c.nome
> from new_procedure ( :par1, :par2 ) n
> join ( select c1.nome
> from clifor c1
> where c1.codigo = n.field_a ) c
> order by c.nome
>
> I'm getting an error on the order by clause.

You missed the JOIN condition

Regards,
Vlad