Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE SY_DB_ACTIVITY  (ID NUMBER);
select * from SY_DB_ACTIVITY;
CREATE OR REPLACE PROCEDURE SP_DB_ACTIVITY
(v_temp IN number) AS 

    v_Id NUMBER;
BEGIN
    EXECUTE IMMEDIATE 'alter session set "_optimizer_squ_bottomup"=false';

    SELECT 1 
    INTO v_Id
    FROM dual;

    INSERT INTO SY_DB_ACTIVITY (id) VALUES(v_Id); 
 END SP_DB_ACTIVITY; 
 /
begin
  SP_DB_ACTIVITY (5);
end;
/
1 rows affected

select * from SY_DB_ACTIVITY;


ID


1