%Type declaration from another schema's table
Posted on 2005-03-21
i'm working on a pl/sql stored procedure that moves data around between schemas. i am doing the development of the procedure in schema1 but interacting with data in schema2. when i try and declare a variable as %Type of a column from a schema2 table, i get an pls-00201 "identifier x must be declared" error. example:
when compiling, oracle only complains about the second of the 2 declarations. it gives the error: pls-00201 "identifier'Lastname' must be declared". is there a way to declare variables using column data types from other schemas? note: i do have full rights to all tables in both schemas.