Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I call a function inside a procedure in plsql

I want to call a function inside a procedure and get it's value so I can use within the procedure but I have no idea how to do that ?? Any ideas ?? My function is the following one , this function returns a collection of employees' ids whose salary out of the max or min salary , I want to use this value in a procedure to update the salaries of those employees to the minimum salary ??

like image 277
Lara Dax Avatar asked Sep 14 '25 22:09

Lara Dax


1 Answers

create or replace procedure P
    a_variable_name number;
begin
    a_variable := a_function('a parameter');
end;
/
like image 117
Shannon Severance Avatar answered Sep 17 '25 12:09

Shannon Severance