10 Replies Latest reply on Jun 21, 2006 8:33 PM by 518099

    ORA-01874: time zone hour must be between -12 and 13

    518099
      I have posted about this is the past but I never got it resolved.

      Error(70,96): PL/SQL: ORA-04052: error occurred when looking up remote object AABR_USER.ENTITLEMENT_TYPE@RADRPAM.ORADEVDB1.CENTRAL ORA-00604: error occurred at recursive SQL level 1 ORA-01874: time zone hour must be between -12 and 13 ORA-02063: preceding line from RADRPAM

      Every time I query a date field across the DB link I get this error. The sql works perfect from my sql prompt on the same box.

      Is there something that I need to get fixed on the other end? Why does this only happen in SqlDeveloper?

      Both DB's are running oracle 9

      Nathan