Re: Use result from function in a Anonymous Block [message #43] |
Mon, 07 January 2002 16:09 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
save script below in a file and run at sqlprompt.
set feed off
set serveroutput on
set define on
prompt enter something
accept n
prompt you entered &&n
declare
i number;
begin
i := fkt;
IF i = 0
THEN
dbms_output.put_line('Result = 0.');
ELSE
dbms_output.put_line('Result = 1.');
END IF;
end;
/
prompt enter one more number
accept r
prompt you entered : &&r
|
|
|