1 2 Previous Next 18 Replies Latest reply: Jul 29, 2013 11:09 AM by joelkallman-Oracle RSS

    DBMS_OUTPUT.PUTLINE Not Working

    user1250676

      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