I have a business data connectivity model for oracle which is working fine. We are changing oracle to Postgres SQL and would like to make necessary changes in the model . One of the issue I am facing is how to pass the variable into the SQL statement. For eg. the current model has
<Method Name="Getcountry">
<Properties>
<Property Name="RdbCommandText" Type="System.String">select * from country where country name like :countryname</Property>...</Method>
<Parameters>
<Parameter Direction="In" Name=":countryname">
<TypeDescriptor TypeName="System.String" IdentifierName="countryname" AssociatedFilter="countryname" Name="countryname">
<DefaultValues>
<DefaultValue MethodInstanceName="Getcountry" Type="System.String">%</DefaultValue>
</DefaultValues>
</TypeDescriptor>
</Parameter>
This works in Oracle but Does not work in PostgresSQL . What I am trying is to do is to pass the value from a UI to the model . The model is deployed in Sharepoint 2016 onprem
