Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "instead of select" trigger
Serge Rielau wrote:
> Daniel Morgan wrote:
>
>> Christian "Raistlin" Gulich wrote: >> >>> "dnh" <nogood_at_using.this.addr.com> schrieb im Newsbeitrag >>> news:40b2c233$1_at_cpns1.saic.com... >>> >>>> One word - VIEWS >>> >>> >>> >>> >>> I have to pass parameters to the procedures, depending to the current >>> query. >>> If it isn't possible, to get the querieng sql statement in a view to >>> pass it >>> to the procedures, views are not a solution for me. >>> >>> Christian >> >> >> >> It is often better to ask questions than to make statements that may >> or may not be true. >> >> You can pass parameters to view created with functions and also by >> using DBMS_APPLICATION_INFO. There is a demo showing this at: >> http://www.psoug.org/reference/dbms_applic_info.html >> >> In 10g you can, in fact, write the equivalent of an INSTEAD OF >> trigger for a select ... check out the ADDM. >>
What we have here is a failure to communicate.
Can you provide me with a translation for this sentence? "pass values from the outer of a join to the inner which is a view"
I've you doubt you know what you intended but I must confess I don't.
Thanks.
With respect to your statement:
"any form of global variables beyond what is considered "stable
environment setup" was frowned upon"
Why?
When I read that all I can think of is ps -ef | grep .... and why is one different from the other?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri May 28 2004 - 01:37:33 CDT