Re: %TYPE DECLARATIONS
From: Herbert Tessemaker <J.Hoekstra_at_civ.utwente.nl>
Date: 1998/01/28
Message-ID: <01bd2bdd$19abd3e0$7c025982_at_utciv2124.civ.utwente.nl>#1/1
Date: 1998/01/28
Message-ID: <01bd2bdd$19abd3e0$7c025982_at_utciv2124.civ.utwente.nl>#1/1
Chech your table privileges. Try grant it.
grtx
Herbert
>
> In PL/SQL I have defined a cursor using the %TYPE attribute. The variable
> that I am declaring is being anchored to a column in a table that belongs
> to different user. For example
>
> CURSOR get_all_rec (in_year owner.table.column%TYPE)
> IS
> SELECT ssn
> FROM all_records
> WHERE year = in_year ;
>
> At compile time, the error "identifier 'table' must be declared". It
> interprets owner as table and table as column.
>
> Sara[EOB]
>
Received on Wed Jan 28 1998 - 00:00:00 CET