How Can i access a type which is stored in some other scheema in my procedure..
I have tried giveing grant and then using it by username.typename..
But it dose not worked..

hi,

try using username.schemaname.typename. it will work.



Ram

In sys user,

CREATE OR REPLACE TYPE NEWOBJECT1 AS OBJECT
(
  NEWATTRIB1 NUMBER
);

grant all on NEWOBJECT1 to scott

in scott user,

declare
test SYS.NEWOBJECT1;
begin
select sal into test.NEWATTRIB1 from emp
where rownum < 2;
end;


Sujit Ku. Mahapatra