Re: Records : Scope and Packages

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 27 Jan 2000 20:04:56 +0100
Message-ID: <949000018.13779.0.pluto.d4ee154e@news.demon.nl>

Did you define the records as types in the package spec? Otherwise they are not visible outside the package.
This seems to be the most likely cause. Personally, I prefer having one package (spec only) with 'generic' definitions in order to avoid cross-relations like you seem to have. If you refer in A to B and in B to A you may end-up with deadlocks during package revalidation. Pinning should avert this problem.

Hth,

--
Sybrand Bakker, Oracle DBA
Robert Shaw <robert_shaw_at_tertio.com> wrote in message news:389082CE.397D602B_at_tertio.com...
>
> Hi,
>
> I'm having some trouble with passing PL/SQL Records between Procedures
> in different Packages. When I try to source, I get "wrong type"
> errors. When
> I change the code so the procedures are in the same Packages, its OK.
>
> ie. If I create identical proc1's in packageA and packageB:
> In packageA
> packageB.proc1(record1); FAILS TO COMPILE
> whilst
> packageA.proc1(record1); IS OK
>
> Its a bit confusing! Any help anyone....
>
> Robert
>
>
Received on Thu Jan 27 2000 - 13:04:56 CST