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

"Martin T." <bilbothebagginsbab5_at_freenet.de> wrote in message news:1151413920.975720.195890_at_y41g2000cwy.googlegroups.com...
: Hi all.
:
: Simple Question: Why does Oracle not support parameters to views?
:
: Now don't tell me it does, it does support a bunch of workarounds which
: all in all will suffice for one problem or the other, but still they
: are workarounds. (I for example will use a PL/SQL function returning a
: ref cursor.)
:
: The question remains - a parameterized View seems to be a feature many
: people would like to use, so it's quite a mystery to me why Oracle is
: not implementing such a thing.
:
: Any opinion on this matter is greatly appreciated!
:
: Thanks,
: best,
: Martin
:

if many people would like to have it, they should submit enhancement requests to oracle

evidently not that many oracle users want such a feature

are you asking from an MS-Access perspective? in that environment the interface is tightly couple to the DB engine, so a parameterized (query) 'makes sense', since the gui can prompt the user

it really doesn't make sense in an RDBMS, since the RDBMS does not control the GUI, and each GUI would have to have it's own way to respond to some sort of message or exception from the database, then continue the operation

++ mcs Received on Tue Jun 27 2006 - 08:32:13 CDT