Oracle 7 to 9 Connectivity PL/SQL Compilation
03/01/2018 11:47
This topic has been extensively discussed here and elsewhere, withrespect to database connection. But what about compiling PL/SQL? We have a 9.2 database containing PL/SQL that needs to compile againsttables in a 7.x database. So we have created an 8i 'in between'database, which contains synonyms pointing to the 7.x tables.

Within the 9.2 database, it is possible using SQLPlus to select datafrom the 7.x tables (via database link to the 8i database). However itis *not* possible to compile PL/SQL code on the 9.2 database thatreferences the same 7.x tables ie: 9i SQLplus -> 9i synonym -> db link -> 8i synonym -> db link -> 7.xtable... works OK 9i PL/SQL -> 9i synonym -> db link -> 8i synonym -> db link -> 7.xtable... does *not* work Has anybody out there used the 8i shim database approach tosuccessfully compile 9.x PL/SQL code against 7.x tables. (And no,upgrading the 7.x databases to a later version is NOT an option for us) Regards,Neil

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
03/01/2018 11:47 - Another possibility that I am not in a position to test is to createviews on the version 9i database that select from the version 8i db.

This should allow the packages to compile.

HTH -- Mark D Powell --

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
03/01/2018 11:47 - Neil <njh3@bnfl.com> wrote in news:1127738859.646036.73120@f14g2000cwb.googlegroups.com: One possible alternative is to create some PL/SQL code in the 8i DB;which gets invoked from the V9.2 DB.


Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below