We have a UNIX box that has the Time zone set as IST. However, for
the Oracle database instance, we need to have the time zone set to
MST. The problem we are facing is as follows:
We have a stored procedure which calls another funtion to get the
Local Time Zone. This function is an External C function which gets
the time zone for the UNIX box by calling the 'C' tzset function to
get the time zone.
Now we tried executing this C function as a stand-alone program at
the UNIX prompt and the time zone returned by this function depends on
the TZ variable set, i.e. if TZ for the UNIX session was set to IST,
output was IST and if it was MST, the output was MST.
Now, we set the TZ variable to MST and then logged onto a sqlplus
session. However, when the stored procedure was executed, the time
zone returned continued to remain IST.
At this point, we thought that this might be because the stored
procedure executes in the Oracle UNIX Id environment (not sure if that
is true) and hence tried setting the TZ variable to MST for the Oracle
ID before starting up the database. The result though was still IST.
Any idea on what is amiss here. How do we go about this?
Any help is appreciated.
Thanks.
Regards,
