Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLSQL Anonymous block

AAPJan 19 2012 — edited Jan 19 2012
I 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....
This post has been answered by 21205 on Jan 19 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2012
Added on Jan 19 2012
3 comments
376 views