Re: Oracle 7 to 9 Connectivity PL/SQL Compilation

"Neil" <njh3_at_bnfl.com> wrote in
news:1127738859.646036.73120_at_f14g2000cwb.googlegroups.com:

> This topic has been extensively discussed here and elsewhere, with
> respect to database connection. But what about compiling PL/SQL?
>
> We have a 9.2 database containing PL/SQL that needs to compile against
> tables 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 data
> from the 7.x tables (via database link to the 8i database). However it
> is *not* possible to compile PL/SQL code on the 9.2 database that
> references the same 7.x tables
>
> ie:
> 9i SQLplus -> 9i synonym -> db link -> 8i synonym -> db link -> 7.x
> table... works OK
>
> 9i PL/SQL -> 9i synonym -> db link -> 8i synonym -> db link -> 7.x
> table... does *not* work
>
> Has anybody out there used the 8i "shim" database approach to
> successfully 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
>
>

One possible alternative is to create some PL/SQL code in the 8i DB; which gets invoked from the V9.2 DB. Received on Mon Sep 26 2005 - 08:45:15 CDT