I have to access the oracle database to get the maximum value in a field of a table.
I have to get this value at the time of mapping.
I was thinking of writing the user defined function to get this value.
Has someone done this type of work.
you can use JDBC receiver adapter. Create a statement with attribute action="SQL_QUERY", where you can access a SQL statement like "SELECT (max) myField FROM myTable WHERE ...
Please have look to Library: