SORTED: Re: Records : Scope and Packages

Thanks for your help. In fact the Record was defined in a database on another
server, accessed via a database link (I didn't mention this in the original mail),
so I tried Thomas's solution and it worked:

On Server A, Package Body A I DECLAREd:

    v_MyRecord PackageB.t_MyRecordType_at_ServerB;

which refered to the Package Header definition on Server B, Package B:

   TYPE t_MyRecordType IS RECORD (String VARCHAR2(10));

Which compiled through the database link.

I also liked Sybrand's idea of a TYPE declaration Package for this kind of thing.

Thanks Again,
Robert

Robert Shaw wrote:

> 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 Fri Jan 28 2000 - 03:11:52 CST