Re: Basic syntax question regarding SUBTYPE statement

From: <nainm_at_my-deja.com>
Date: Mon, 14 Jun 1999 15:14:15 GMT
Message-ID: <7k367s$r3r$1@nnrp1.deja.com>

It's working for me. I dont think it's a syntax problem. Check for the grants on table1. I assume user2 is the owner of table1 and user1 is granted direct access on this table.(access thru role is not sufficient if you want to create a package/procedure/function)

In article <376507A6.655C0386_at_xmission.com>, James Knowles <kaa_at_xmission.com> wrote:
>
> Sorry for these basic questions....
>
> I can do the following without a problem:
>
> CREATE OR REPLACE PACKAGE TestPackage AS
> SUBTYPE t_Test IS table1.col1%TYPE;
> END TestPackage;
>
> However, the following fails. Is there some way to do this, or is it
> illegal? I cannot find an answer in ORACLE8 PL/SQL Programming. I'm
> connected as user1. If it's not allowed, is there some way around it?
>
> CREATE OR REPLACE PACKAGE TestPackage AS
> SUBTYPE t_Test IS user2.table1.col1%TYPE;
> END TestPackage;
>
> Thanks!
>
> --
> It's coming... http://www.countdown9199.com
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 14 1999 - 10:14:15 CDT