Skip to Main Content
Integration


This is an IBM Automation portal for Integration products. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.


Status Not under consideration
Workspace App Connect
Created by Guest
Created on Jul 25, 2017

Graphical Mapper - Parameterised Stored Procedure or Function call in Select Where Clause - Oracle DB

Kindly refer the PMR (31762,999,796) for more detailed coversations related to the issue which isn't *documented* in IBM information center at the moment.

This RFE is a request to get this documented, the UseCase / Scenario in which 'Oracle Parameterized Packaged Stored Procedure/Function is written in the 'Where' clause of SELECT statement, using Graphical Mapper' in IIBv10 and WMBv8.

In WMBv8, Applications were designed/implemented to call Oracle tables/views with Packaged Parameterized Function in its where clause, have been working properly with no issues. It seems, it doesn't call function in the where clause, whereas it passes that select/where clause to Oracle to handle it at runtime. It appears IBM doesn't have a use case for this scenario, with where clause function (with parameters), which gets evaluated and Oracle database handles it at the runtime.
As far as IIBv10FP009 is concerned, the same behaviour works fine too. The only difference we have found out is that the graphical mapper has more validations in syntax while formulating call to oracle table/view with function in where clause. Fixing the expected blank space issues in the passed parameters of the called function, resolves the xpath issue. It appears, xpath errors were the false errors and more of related to syntactical and validation issues, set at toolkit level, on the graphical mapper. Hence, IBM can document this use case somewhere for the future references.

Following is the response from IBM in the aforementioned PMR:

I believe the map has modified to make these SQL Select Where clauses like 1=cdm_product_conversion.set_ret_main_bft( ? , ?1 , ?2 ) That is adding the space character after each parameter place holder, as would be done when using drag drop action in the SQL clause builder from the "available inputs for column values". The validation issue arises because the comma character used to separate the Oracle function call parameters is not an expected SQL syntax character, and the product requires a occurrence of a whitespace character triggers our validation to recognise each separate placeholder. Note that when editing the Mapping Select Where clause the user is promoted and cannot click "OK" until the syntax is valid. For IBM to document the use case of including an Oracle function call in a Mapping Select Where clause would require that full testing of the feature be added to the product release process in addition to updating the documentation to detail its use.
If the customer wishes this we would suggest that an RFE is raised.

Idea priority Medium
RFE ID 108249
RFE URL
RFE Product IBM App Connect Enterprise (formerly IBM Integration Bus)
  • Admin
    Ben Thompson
    Reply
    |
    Jul 31, 2023

    Idea Review. As part of our policy for regularly reassessing aged ideas we have recently discussed this enhancement request again. Unfortunately, with no new comments or further signs of support beyond the initial 1 vote from six years ago, on this occasion it has been decided that we won't be taking this idea further forward.

  • Guest
    Reply
    |
    Oct 14, 2020

    RFE Review. Apologies for the length of time this RFE has been in Submitted status. Thank you for the obvious time you have invested in describing this scenario and the discussions you had with our Service team. This is very much appreciated. Status of the RFE is updated to Uncommitted Candidate.