PLSQL Anonymous block
AAPJan 19 2012 — edited Jan 19 2012I execute the below PLSQL Anonymous block in isqlplus in 10g enterprise edition.... after creating user, table,inserting data in it etc....
declare
v_id number:=1;
v_first_name varchar2(30);
v_last_name varchar2(30);
begin
select first_number, last_number into v_first_name, v_last_name
from student
where id=v_id;
dbms_output.put_line('First Name is '||v_first_name||' Last name is '|| v_last_name);
exception
when no_data_found then
dbms_output.put_line(' There is no record for student '|| v_id );
end;
I am getting this message ...
PL/SQL procedure successfully completed.
But the data which i am expecting, which I have put in the table student is not displaying....
What is the problem....