Re: Procedures-Views mix?

Me Confoosed!

A view in effect does have parameters, just use the where clause of the view.
Anyway, if you did ceate a procedure which returned records, you will probably only get one record at a time and the procedure will have to be called many times with different 'parameters' and will not do anything for performance.

Mark

Alex Yurchenko wrote in message <3745B724.E1C415FF_at_aug.edu>...
>Hi everyone
>
>I'd like to create a "view with parameters", or basically I want a
>procedure which returns records. Is there is any way to do that. Thanks.
>
>--
>
>home e-mail: snake76_at_mindspring.com
>work e-mail: ayurchen_at_aug.edu
>home page: http://www.mindspring.com/~snake76
>
>********************************************************
>Religion is the opium of the people.
> C. Marx
>********************************************************
>Friends will be friends
> "Queen"
>********************************************************
>Knowing what
>thou knowest not
>is in a sense
>omniscience
> P. Hein
>********************************************************
>Teaching should be such that what is offered is perceived
>as a valuable gift and not as a hard duty.
> A. Einstein
>********************************************************
>
>
Received on Mon May 24 1999 - 04:56:05 CDT