No, it's by no means a 10g thing. It is unsupported/undocumented stuff.
It's like using an 18-wheeler to drive from home to a grocery shop and
back. It works, but..... On top of that, you probably wouldn't want to
grant execute on DBMS_SUPPORT to public. In other works, DBMS_SUPPORT
is not an answer. Create function as the user system, create public synonym
and grant execute on the function to public. When oracle doesn't
want to do it for you, you have to take matters in your own hands.
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
> Sent: Friday, October 15, 2004 4:37 PM
> To: jonathan_at_jlcomp.demon.co.uk; Mladen.Gogala_at_aetn.com;
> thomas.mercadante_at_labor.state.ny.us; mark.powell_at_eds.com;
> oracle-l_at_freelists.org
> Subject: RE: own session's SID
>
>
> Is this a O10g thing? I can't find any object name
> dbms_support in my 9.2.0.4 database.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 15 2004 - 15:43:56 CDT
