can i store the output of boolean values into a table?
skudFeb 9 2011 — edited Feb 9 2011the output of the below coding is '1' and '0'...
i want to store that '1' and '0' in a table...
but i cant do that pls help me....
how to store it?....
DECLARE
EID VARCHAR2 (20);
BL BOOLEAN := TRUE;
BEGIN
SELECT EMP_NO
INTO EID
FROM LEAVE_FORM
WHERE EMP_NO =1;
BL := TRUE;
DBMS_OUTPUT.PUT_LINE(sys.DIUTIL.bool_to_int (BL));
insert into t1 values(BL);-----------------------------------------------------error
EXCEPTION
when no_data_found then
BL := FALSE;
DBMS_OUTPUT.PUT_LINE(sys.DIUTIL.bool_to_int (BL));
END;
Edited by: 794244 on Feb 9, 2011 3:11 AM