Re: Boolean variable

hemant.bs11_at_gmail.com wrote:

> I have a procedure that returns a boolean value,

           ^^^^^^^^^

It should be a *function*, not a procedure.

> How can i print this
> value or is there any way from which i can fetch the value returned
> from the procedure to a variable of a varchar2 datatype

declare
  x varchar2(80);
begin
  x := (case your_boolean_function when true then 'true' when false then 'false' else 'unknown' end) ;
  dbms_output.put_line(x);
end ;
/

C. Received on Tue Jan 29 2008 - 10:25:02 CST