How to set sessiontimezone for scheduled job session

Hi all,

  I have procedure which inserts into a table the values of type TIMESTAMP WITH LOCAL TIMEZONE,
I have the sessiontimezone value set to say '+05:30' so the values inserted into above table will use this session timezone

Now I am scheduling the above procedure using dbms_job package, Now I am seeing the values as if the sessiontimezone is '+00:00'. the session_user is same for both the cases,

Plz let me know how we can set sessiontimezone for scheduled job as well

Thanks in advance
Basavaraj Received on Mon Apr 17 2006 - 07:00:27 CDT