MQSeries.net :: View topic - Disable default schema name when invoking ORCL stored proc

dangn

I'm having an issue invoking an Oracle stored procedure from WMB v6. Here is how I defined the external name of the stored procedure in WMB:

EXTERNAL NAME "grp.eai_query_available_coverages"

The problem is that when WMB invokes the stored procedure, Oracle rejects it because WMB includes the schema name "grp". I was told by an Oracle DBA that I should only invoke the stored procedure with just the name (unqualifed call) eai_query_available_coverages. I tested invoking this stored procedure using SQL Navigator and confirmed with the Oracle DBA that grp have to be removed.

However, if I remove "grp" from EXTERNAL NAME definition as follows:

EXTERNAL NAME "eai_query_available_coverages"

WMB, by default, adds default datasource name and user account to the stored procedure as follows:

datasourcename.useraccount.eai_query_available_coverages

This doesn't work either because Oracle doesn't recognize this syntax.

Question: Is there a way for me to configure WMB to NOT include the datasourcename/schema when invoking the stored procedure? I'm looking for a way to just invoke the stored procedure as eai_query_available_coverages (no schema, no datasourcename) from WMB

Thanks