This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jul 29, 2013 9:09 AM by jkallman RSS

DBMS_OUTPUT.PUTLINE Not Working

user1250676 Newbie
Currently Being Moderated

I am new to Application express.I am unable to display anything on the screen (under the Results tab) in SQL Commands. I have the following program:

 

set serveroutput on;

Declare

vfirstname varchar2(35);

vlastname varchar2(35);

ccounter CONSTANT NUMBER:=0;

begin

select first_name, last_name into vfirstname, vlastname

from student_sby

where student_id=123;

dbms_OUTPUT.PUT_LINE ('student name: ' || ' ' || vlastname);

end;

 

When I run the program, it does not produce any error and any out put.

If I just have the select statement I get the results displayed.

select first_name, last_name

from student_sby

where student_id=123;

Any help will be appreciated. I am using Oracle Application Express version 4.x.

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points