Re: Setting v$session.program for dbms_job process?

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

------------------- grz01

StefanKapitza skrev:

> grz01_at_spray.se wrote:
> > Thanks for the hint, Mladen,
> >
> > Using DBMS_APPLICATION_INFO in seems I can set the v$session fields
> > Action, Module, and Client-info.
> >
> > However, I could not find a function there to set v$session.program,
> > which is what I would really like to do.
> >
> > Anyone knows how to do this?
> >
> > TIA,
> > ---------------------- grz01
> >
>
> <snip>
>
> program is "operating system program name"
>
> iI doubt you can change it.
>
> regards
>
> s.kapitza
Received on Fri Jun 09 2006 - 02:33:58 CDT