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

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