TEXT_IO.PUT_LINE ???

From: rahmu <sathya_at_flash.net>
Date: 1997/10/16
Message-ID: <34464C3F.5ACB_at_flash.net>#1/1


I wrote this procedure with the procedure builder1.5.5. It is compiling succesfuly in the program unit. If i put the procedure in stored program unit, it's give the error message ( PLS - 00201: identifier 'TEXT_IO.PTU_LINE' must be declared ) If i run this procedure in PL/SQL INTERPRETER it will display only with in the single cote text. But i want the value of the variable also (v_emp.empjob) in the end of the TEXT_IO.PUT_LINE. Thanks for your help.

PROCEDURE emprec IS
BEGIN
  DECLARE
   TYPE t_studentrecord IS RECORD(

     empname emp.ename%TYPE,
     empjob  emp.job%TYPE);
   

   v_emp t_studentrecord;
BEGIN
   SELECT v_emp.empname, v_emp.empjob
   INTO v_emp
   FROM emp
   WHERE empno = 7839;

   TEXT_IO.PUT_LINE('The value of the variable is '||v_emp.empjob); END;
END;



Please welcome to my home -- http://www.flash.net/~sathya
                 
               ***** HAVE A NICE DAY *****
Received on Thu Oct 16 1997 - 00:00:00 CEST

Original text of this message