I'm currently using Oracle 10g and Toad 11.5. I'm trying to call an API from an anonymous block. So when I recompile the API after adding "DBMS_output.put_line" and then execute the block, I keep getting this error:
"ORA-06508: PL/SQL: could not find program unit being called".
But when I end the old session and open a new one, it works fine so it's making me restart the session every single time. Can someone help me here?