Thanks for the reply.
Did you defined “PO_VERSION_ID” as AdapterService JDBCFieldType output?
- Yes Indeed I have defined…
Also make sure your query returns based on PO_NUM and it exists in the DB…check your query with any db client tools also
- Yes I have run the same query using the client DB tools. It does indeed return me rows.
Also I did Try out the following too.
I created a dummy table with a single column PO with the data type being defined as CHAR(7) in oracle 10G.
Then I did create an adapter service using select SQL template. The where clause , I defined it as PO = ? with PO field mapped to java.lang.String.
The select returns me PO as the out put. But still no success.
Is the mapping between CHAR of oracle and java.lang.String datatype in webMethods failing?
Any help would be highly appreciated.