Re: PL/SQL : How do you echo text to screen ?

See your manual regarding use of DBMS_OUTPUT package.

This will serve your needs...

SET SERVEROUTPUT ON begin

   declare product char(7);
   begin

      select part_number
         into product
         from table1
         where part_number='123456';

       DBMS_OUTPUT.PUT_LINE('Product is:'||product);

   end;
end;

   DBMS_OUTPUT.PUT_LINE('');
Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954

E-Mail Work(Current Client): jentilucci_at_notes.seagate.com

                           Business: infosys_at_aol.com
                                Home: AlexJent_at_aol.com