I’ve got a following problem I’ve spend day to find a solution for.
When I’m trying to get dbms_output tab and press a red dot button “Turn output on” as a SYS, everything works just fine. But if I do the same as any other schema user, for instance SM, I get an error instead:
ORA-04067: not executed, package body “SM.DBMS_OUTPUT” does not exist
ORA-06508: PL/SQL: could not find program unit being called: “SM.DBMS_OUTPUT”
ORA-06512: at line 1
I’ve already tried to rerun dbmsotpt.sql script and it didnt help. Whatever info I could find on the internet it’s mostly about “it should work from the box, just press the red dot button”