When I try to run any procedure from a determinated user I get this error:
ORA-06550: line 2, column 10: PLS-00302: component 'PROVA_DEBUGGING' must be declared ORA-06550: line 2, column 3: PL/SQL:Statement ignoredI get this error when I execute the procedure with TOAD and SQL*Plus. The procedure is really simple (I've created it only for testing):
CREATE OR REPLACE PROCEDURE PROVA_DEBUGGING IS BEGIN DBMS_OUTPUT.Put_Line('TRYING TO DEBUG'); END PROVA_DEBUGGING; /I get this error with all the procedures and functions I've tried for this user.
At the beginning I thought it could be a user problem. But I created another user, with the same properties that I've been having the problems with, then I imported all the data. Therefore I have a clone user. With the second, I can run all without any problem, but with the first I always get the error.
Do you have any idea how to help? Thanks in advance.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.