webMethods Integration Server is ver 6.1
Oracle ver 8.1.7.x
Somebody in my dev team wrote a wm java service to piece together a sql statement depending on what information is available at run time.
I needed to search on a line number (VARCHAR2 in oracle table), so I mapped a String variable lineNumber to the service that builds the query.
Everything works fine until the execSQL step. I have stepped through the service and my lineNumber = 1. I have looked at the sql the java service builds and that looks ok.
"and line_number = ‘1’ "
I have copied the sql built from the service and pasted in an Oracle sql tool and the query runs fine.
But when wm execSQL runs, it errors with this ClassCastException
Attached is screen print of pipeline and results just before I go to the service that builds the sql query and attempts to run it.