SQL Error [6550] [65000]: ORA-06550

Question

When I try in mi connection using DBeaver to my RDS Oracle instance the following query from the RDSADMIN user, Im following the guide to use a RDS Oracle as a source for AWS DMS -https://docs.aws.amazon.com/es_es/dms/latest/userguide/CHAP_Source.Oracle.html#CHAP_Source.Oracle.Amazon-Managed-:
BEGIN
  rdsadmin.rdsadmin_util.grant_sys_object(
    p_obj_name  => 'ALL_VIEWS',
    p_grantee   => 'oracle_demo',
    p_privilege => 'SELECT'
  );
END;

Im getting the following message error:
SQL Error [6550] [65000]: ORA-06550: line 2, column 12:
PLS-00302: component 'RDSADMIN_UTIL' must be declared.
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

Answer

Hi,

Check to verify if you have any objects with the same name as the schema. You might have an object named 'rdsadmin' in your database and when you are calling "rdsadmin.rdsadmin_util.grant_sys_object" the object name is being resolved so it doesn't try and evaluate rdsadmin as a schema name.

Run:

`select OBJECT_TYPE,OWNER,OBJECT_NAME from all_objects where OBJECT_NAME='RDSADMIN';`

And drop any OBJECT_NAME with the name 'RDSADMIN' that is not owned by 'RDSADMIN'.

Answer

Hi,

Look at answer by Alex Poole  in this question: https://stackoverflow.com/questions/28706077/why-do-i-get-pls-00302-component-must-be-declared-when-it-exists

It may be similar to your issue.

Best,

Didier

SQL Error [6550] [65000]: ORA-06550

Relevant content