need help with this pl/sql block
503766May 26 2006 — edited May 26 2006hi iam preparing for 1z0-001 exam..iam not able to figure out this .plz help
Which line in the following PL/SQL block will raise an exception?
1 TYPE emp_typ is RECORD (
emp_no VARCHAR2(20),
name scott.emp.name%TYPE);
2 emp_rec emp%ROWTYPE;
3 BEGIN
4 SELECT * INTO emp_rec FROM emp
WHERE emp_no=12;
5 emp_rec.emp_no := emp_seq.nextval;
6 INSERT INTO emp VALUES (emp_rec);
7 END;
1. Line 1
2. Line 2
3. Line 4
4. Line 6
ans:D. sybex text book
how is it possible??/
thank u
rajiv