XPost: comp.database.oracle, comp.databases.oracle.misc, comp.da   
   abases.oracle.server   
   XPost: comp.databases.oracle.tools   
   From: Jane@dossss.com   
      
   Hi All,   
      
   I created a DBLINK on a 9i server to a 7.1.4 server.   
   CREATE DATABASE LINK my_link CONNECT TO rem_user IDENTIFIED BY rem_pwd USING   
   'my_tnsentry';   
      
   - But when I query through the link using   
   "select max(t_date) from table1@mylink;", I get the following error:   
   select max(t_date) from table1@mylink   
                                           *   
   ERROR at line 1:   
   ORA-24439: Connections to Oracle7 server are no longer supported   
   ORA-02063: preceding line from MY_LINK   
      
   When I connect using SQLPLUS, I get a similar error as above:   
   /export/home/mmmm> sqlplus rem_user/rem_pwd@my_tnsentry   
      
   SQL*Plus: Release 9.2.0.2.0 - Production on Mon Oct 13 17:15:42 2003   
   Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.   
      
   ERROR:   
   ORA-24439: Connections to Oracle7 server are no longer supported   
      
   Enter user-name:   
      
      
      
   How do I query a remote Oracle 7 database from Oracle 9i?  My queries will   
   run from a stored procedure in the 9i database.   
      
      
   Thanks in advance   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)