Re: The Oracle-No-Parameterized-View mystery ...

sybrandb_at_yahoo.com wrote:
> Martin T. wrote:
> > DA Morgan wrote:
> > > Martin T. wrote:
> > > > Hi all.
> > > >
> > > > Simple Question: Why does Oracle not support parameters to views?
> > > >
> > > >
> > > What do you mean by parameters to views? Please be specific. Thanks.
> > >
> >
> > CREATE VIEW complex_sorted_response (param1 DATE) <- there goes the
>
> Ah, I see, you advocate the uncontrollable Garbage In Garbage Out
> approach, and for THAT purpose you need the kludges you erroneously
> describe as 'parameters'
>

I'm afraid I do not know what the "Garbeage In Garbage Out" approach is.

> Aren't you aware that views are *compiled*. Know what *compiled* means.
>

No, I was not aware of this. Also I do not understand why this should be a problem, since a query with a bind variable is also compiled, right? And I still can use an arbitrary value for the bind variable? So in principle it should be possible to have a VIEW with a bind variable = parameter? (note the question marks)

Also - Tom Kyte states that they support it and I think he also uses the example he provides with the userenv variables (which I call a workaround). I do not see why it should not be possible to have a direct syntax for parameterized views.

> Know *dynamic sql* will bring Oracle to its knees?
>

Yes, I would agree that dynamic SQL tends to be evil.

> Or do you think
> a) Oracle is sqlserver sold by a different vendor
>

I do not know sqlserver. I have only worked with oracle and PL/SQL for the last year or so.

> b) you know everything better.
>

No. Would I think that, I'd no need to use this newsgroup.

best,
Martin Received on Wed Jun 28 2006 - 05:23:09 CDT