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.