hi @jkgala
I have created a stored proc in sql developer that does nothing, but is the same name as yours:
create or replace procedure custom_drop_temp_objects as
begin
-- do something
null;
end;
/
If I call that using a DB Sql Executor, it executes the node without error, provided that I don’t have “Support multiple SQL statements” ticked, and made sure that there was the ; after the “end”.
[edit- updated/fixed screenshot]
If I have it ticked, or missed out the semi-colon (so I just had “end” and not “end;”, I get the ORA-06550 message that you got.
As you can see from the screenshot, I was able to make multiple calls to stored procedures within a begin-end block.