On 22 Jan 2002, at 1:54, Claudio Valderrama C. wrote:

> ""Sandeep"" <sandeep@...> wrote in message
> news:3C4C4B63.32707.1DD4911@localhost...
> > Is it possible in any way to use Stored Proc in a view?
>
> Pressed SEND too fast...
> you can put a procedure inside the WHERE clause of a VIEW. I think it's a
> validation error in trying to block procedures, not a thing that was allowed
> specifically.

What I meant was to get the data using a stored proc (because the
queries, for whatever reason, are not using the indices and this is
slowing the response time) and use it in a view.

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz