Search code examples
oracle-databaseplsqlout-parameters

Is it true that OUT parameter must be assigned a value in PL/SQL?


create or replace procedure ppp(ot OUT number)
is
begin
null;
end;
/

This works fine on being called.


Solution

  • Test-runs show that it is essential but not mandatory.