Oracle建立带参数的存储过程，出现错误

[guolin]

create or replace procedure pro3 (
tempno in scott.emp.empno%type,
name1 out scott.emp.ename%type,
job1 in out scott.emp.job%type
)
as
myjob scott.emp.job%type;
myname scott.emp.ename%type;
begin
select job into myjob from scott.emp where empno=tempno;
select ename into myname from scott.emp where empno=tempno;
name1:=myname;
job1:=myjob;
end;

结果提示以下错误
Compilation errors for PROCEDURE IDOYU.PRO3

Error: PLS-00201: 必须说明标识符 'SCOTT.EMP'
Line: 2
Text: tempno in scott.emp.empno%type,

Error: PL/SQL: Compilation unit analysis terminated
Line: 0
Text: create or replace procedure pro3 (


不懂是什么情况，请高手帮忙解答，感谢

[iqlife]

我这里可以正常运行
用户是否有访问SCOTT权限

[guolin]

原来如此，感谢