Re: accessing (packaged) procedure name within procedure

Frank wrote:

> Daniel Morgan wrote:
>
> > Comments interspersed.
> >
> >
> > Jetlag wrote:
> >
> >
> >>Linux, Oracle 9.2.0.1
> >>
> >>Does anyone know of a system variable or some kind of logic which
> >>would return a string containing the name of the currently executing
> >>procedure?
> >
> >
> > It can not be done nor does it make any sense unless you are assuming an
> > Oracle database with a single connected user.
> >
> >
> >>.MY_PAK
> >>0x55dafac8 1 anonymous block
> >>
> >>Suggestions would be most welcome. Thanks.
> >>
> >>-- jetlag --
> >
> >
> > Take a look at:
> > v_$sga
> > v_$open_cursors
> > v_$sql_area
> > v_$sessions
> >
> > They may be of some help.
> >
> > --
> > Daniel Morgan
> > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> > damorgan_at_x.washington.edu
> > (replace 'x' with a 'u' to reply)
> >
> >
> Would be nice, though - so I can finally migrate
> from SQL Server's @@PROCID...
>
> --
> Regards, Frank van Bortel

Migration means functionality ... not implementation. In SQL Server one builds temp tables. In Oracle temp tables are completely unnecessary.

The migration is easy. Just do Oracle in Oracle and SQL Server in SQL Server.

You don't need @@PROCID ... just code what you need in an Oracle appropriate manner. For example use packages ... SQL Server doesn't have them of course ... but they maintain state for the length of a session.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)