Stored Procedure with multiple select statements
I have a stored procedure like this
procedure Test( in Nr int );
begin
declare Result int;
select Nr-5;
set Result = (select Nr+5);
select Nr,Result;
end
As a result of
call Test( 100 );
I expect to see
Quote
100 , 105
but I see the result of the first select statement:
Quote
95
What does I make wrong?
Subject
Views
Written By
Posted
Stored Procedure with multiple select statements
2433
February 15, 2020 04:48AM
736
February 15, 2020 11:38AM
623
February 16, 2020 07:33AM
622
February 16, 2020 09:18AM
683
February 19, 2020 04:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.