Oracle Solution for Error ora-24037

Solution for Oracle Error ORA-24037

ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE

What triggered the Error:

e schema specified in the QUEUE_NAME parameter of CREATE_QUEUE is not the same as the schema specified in the QUEUE_TABLE parameter.

What should we do to fix it:

e the same schema name for both the QUEUE_NAME and QUEUE_TABLE parameters and retry the command.