TEXT_IO.PUT_LINE ???
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