Evaluating a value inside stored procedure.

[milmand]

Please help!
Inside my stored procedure, I need to retrieve a value from a table, evaluate it and perform logic based on result.
Ex:

declare
X number;
begin
x = select max(length(id)) from user_id where ... ;
if
x=5
then
step1
else
step2
end if;


How to hande this situation correctly?

 

[microsky]

The SQL should be
select max(length(id)) into X
from user_id where ... ;

Rgs,
microsky

 

[milmand]

That helped.
Thank you!