Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error when executing a procedure - ORA-06550:PLS-00302: component '' must b

834448Feb 4 2011 — edited Feb 4 2011
When attempting to execute a simple procedure in my own schema, I'm having an error thrown. Can someone tell me why?

Here's the execution code

BEGIN
execute myschema.RUN_NEW_SCRAMBLE;
COMMIT;
END;


This is the error that follows:

ORA-06550: line 2, column 11:
PLS-00302: component 'RUN_NEW_SCRAMBLE' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored


when I run the simple command:

exec RUN_NEW_SCRAMBLE;

It works like a charm.

Please advise.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2011
Added on Feb 4 2011
6 comments
4,294 views