Re: Objects in Packages?

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 25 Feb 2007 22:06:41 -0800
Message-ID: <1172470001.525454.151500@a75g2000cwd.googlegroups.com>

On Feb 25, 10:57 pm, "Michael42" <melliot..._at_yahoo.com> wrote:
> Hello,
>
> in Oracle 10g R2 can Packages contain Objects (TYPE MyObj AS
> OBJECT...) as it does with functions and procedures?
>
> Thanks,
>
> Michael

No. Objects are top-level OR (Object-Relational) entities in Oracle and you can't declare them in PL/SQL packages (and I doubt this will change in 11g or any future release.) The only option you have is to create object types using CREATE TYPE and instantiate them from PL/ SQL. Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Mon Feb 26 2007 - 00:06:41 CST