| Use result from function in a Anonymous Block [message #32] |
Sat, 05 January 2002 04:31  |
Aykut
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
Used software : W98, Oracle 8i, SQL Plus
FUNCTION
----------------------------------------
CREATE OR REPLACE function FKT()
return Number
is
begin
return 0;
end;
----------------------------------------
ANONYMOUS BLOCK
----------------------------------------
DECLARE
i NUMBER;
j_value NUMBER;
BEGIN
i = FKT();
IF i = 0
THEN
dbms_output.put_line('Result = 0.');
ELSE
dbms_output.put_line('Result = 1.');
END IF;
&j_value;
END;
/
----------------------------------------
QUESTION
After the Function return the "return-value",
I want that first of all the IF part should done.
But here is the Problem.
After I get the result from the function,
there is the prompt to enter the j_value.
But I want the output from the IF-Part.
How can I do that ?
bye
Aykut (from Germany)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
