Re: Boolean variable

From: codadilupo <>
Date: Tue, 29 Jan 2008 17:25:02 +0100
Message-ID: <479f535e$0$16031$> 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

  x varchar2(80);
  x := (case your_boolean_function when true then 'true' when false then 'false' else 'unknown' end) ;
end ;

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

Original text of this message