Why not just create another view, which is a view of the view? I have
highly nested views on my databases.
Jon
On Tue, 9 Mar 2004, Alexander Hachmann wrote:
> Hello,
> I know that this was discussed many times, but all the answers did not help
> me yet.
> I need to create a Procedure that returns the same data as a view does
> except, that the the
> data was filtered by a parameter.
> I want to execute a procedure with a parameter and get back a 'view'.
> I only made prcedures giving back simple values. Can they give back data as
> Views does.
> I dont want the procedure to create a view on which i have to query again
> because the query the Procedure does
> can go over more stages than just this one. The procedure calls another
> procedure and handles this as a subselect.
> Can any one help me?
> Thx,
> Alexander
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>