ERROR at line 4: ORA-06550: line 4, column 5: PLS-00320: the declaration of the type of this expression is incomplete or malformed ORA-06550: line 2, column 1: PL/SQL: Item ignored ORA-06550: line 4, column 1: PLS-00320: the declaration of the type of this expression is incomplete or malformed ORA-06550: line 10, column 10: PL/SQL: ORA-00904: : invalid identifier ORA-06550: line 9, column 1: PL/SQL: SQL Statement ignored
declare
type emp_detp_record is record
(
emp emp%rowtype,
dept dept%rowtype
);
emp_dept emp_detp_record;
begin
select * into
emp_dept
from emp,dept
where emp.deptno =dept.deptno
and empno =7839;
end;
/