Re: Toad timezone error

Posted by ErmanArslansOracleBlog on Jul 07, 2017; 6:50am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Toad-timezone-error-tp2906p2910.html

Are the Oracle Homes(Oracle Client) that are used by Toad and Sqlplus same?
I think a higher version of Oracle Home (Oracle Client) is required for Toad.
For example:
if you use a Oracle10 database in which a UTC time zone is already stored, this can not be retrieved from a Oracle9 client.

Ensure you are using the same Oracle Client for both Toad and sqlplus. I think sqlplus uses a newer version of Oracle client. If so, choose the same for Toad.(in the initial connection page, in the oracle home editor)