Re: View with parameters ?

Vincent FABRI ïèøåò â ñîîáùåíèè <8jqsl7$45i$1_at_wanadoo.fr> ...
>Hi,
>Is possible create view with parameters ?
>If so, where can i find sample and syntax ?
>Thank.
>-------------------------------------------------------------------
>http://hydravions.decollage.org
>-------------------------------------------------------------------
>

This is how it is done in DBMS Linter (Russia):

1 ?reate a VIEW (without parameters)
2 Create a stored procedure with the parameters necessary for the VIEW, e.g. p1 int, p2 char, p3....
3 Form a query inside the stored procedure:

    -query="select col1,col2,.. from view where col_x="||to_char(p1) || "and col_y=" ||p2 ....

• open cursor query ...
  • fetch from cursor...

4 The procedure returns the requested selection from the VIEW

Technical writer DBMS Linter Received on Wed Jul 05 2000 - 00:00:00 CDT