- This topic has 2 replies, 1 voice, and was last updated 8 years, 4 months ago by
.
-
Posts
-
-
Hi,
I am trying to pull data from Oracle View using WCF Oracle EBS adapter. I am able to retrieve all the data from the View. However, when I try to use Filter, I get below error:
ORA-00933: SQL command not properly ended —> Oracle.DataAccess.Client.OracleException ORA-00933: SQL command not properly ended
Below is XML that gets generated that calls the View:
<ns0:Select xmlns:ns0=”http://schemas.microsoft.com/OracleEBS/2008/05/Views/APPS/PERSON_V“> <ns0:COLUMN_NAMES>*</ns0:COLUMN_NAMES><ns0:FILTER>EMP_NUM=’X9947′</ns0:FILTER></ns0:Select>
If I leave <FILTER> tag blank, I get all the rows without any problem. I also checked column name used in the Filter and tried other columns also but got same error.
Any help is appreciated.
Thanks,
-
Hi,
Check the following MSDN article on how to use the Oracle E-Business Adapter to create and publish a WCF service, particularly the section titled “Modify the .cs file”:
http://msdn.microsoft.com/en-us/library/dd788356(BTS.10).aspx
Hope this is helpful in resolving your issue.
Daniel.
-
Thanks Daniel for quick response. However, solution I am trying is from BizTalk and according to the documentation (see links below) Filter clause should work in xml. I am not sure if it does not work because I am using Filter clause against the View. But I don’t think that is the problem. Even Request XML looks like what it is supposed to be.
I am not really sure what the issue is. If xml had issue, it would not return resultset of all the rows when I pass empty Filter.
http://msdn.microsoft.com/en-US/library/dd788338(v=BTS.10).aspx
http://msdn.microsoft.com/en-US/library/dd788326(v=BTS.10).aspx
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.