Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Setting v$session.program for dbms_job process?
Sybrand Bakker wrote:
> On 9 Jun 2006 00:33:58 -0700, grz01_at_spray.se wrote:
>
> >OK, the thing is when starting a job with DBMS_JOB(),
> >it seems I always get a null value in this field.
> >I would like to set it to something else.
> >
> >There must be a way that other applications (like sqlplus, toad, etc)
> >propagate this value to Oracle.
> >The Oracle-engine cannot know the name of the executable on a remote
> >host, can it?
> >But still the program-name shows up for those applications...
> >
> >Regards
>
>
> you can set the application_info column and the module colum using the
> dbms_application_info package.
>
>
> Please stop top-posting. Humans happen to read from top to bottom not
> from bottom to top.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Thanks Sybrand,
Yes, I already got that info from Mladen.
But what about v$session.program ?
How does applications set that value ?
Is it not possible from PL/SQL process ?
Regards
------------------- grz01Received on Fri Jun 09 2006 - 03:50:13 CDT