Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: v_$session in 9.2

Re: v_$session in 9.2

From: Boris Nikolaev <ierdna_at_freenet.de>
Date: Fri, 10 Dec 2004 15:57:54 +0100
Message-ID: <31trrjF3gv05jU1@individual.net>


i have set O7_DICTIONARY_ACCESSIBILITY=TRUE - the same result: on trigger compilation I've got an error:

 ORA-00984 Coumn no allowed here

"Terry Dykstra" <tddykstra_at_forestoil.ca> schrieb im Newsbeitrag news:fb_td.9949$Ya4.659_at_edtnps84...
> Is the init.ora parm O7_DICTIONARY_ACCESSIBILITY causing issues here?
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
>
>
> "Boris Nikolaev" <ierdna_at_freenet.de> wrote in message
> news:31r33dF3daklsU1_at_individual.net...
> > thank yo, but please read my posting further. I know, that it works with
> v_$
> > views -> v$views, but the procedure does not nevertheless works in
> > trigger!!!
> >
> > "deepa balu via OracleMonster.com" <forum_at_OracleMonster.com> schrieb im
> > Newsbeitrag news:05bda320a4984d7f81f12be8ec9a8326_at_OracleMonster.com...
> > > Try this
> > > Instead of v_$ views use v$views
> > >
> > > CREATE OR REPLACE function current_process return varchar2 is
> > > Result varchar2(64);
> > > begin
> > > declare
> > > my_sid number;
> > > begin
> > > result := NULL;
> > > SELECT SID into my_sid from v$mystat where rownum=1;
> > > SELECT PROGRAM INTO result from V$SESSION where SID=my_sid;
> > > if result is NULL then
> > > SELECT MODULE INTO result from V$SESSION where SID=my_sid;
> > > end if;
> > > return(Result);
> > > exception
> > > when others then NULL;
> > > end;
> > > end current_process;
> > > /
> > >
> > > --
> > > Message posted via http://www.oraclemonster.com
> >
> >
>
>
Received on Fri Dec 10 2004 - 08:57:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US