I am working on a SP call which returns a list of records which in turn are spooled to a file.
I am making a SP call to Oracle DB view by StoredProcedurewithSignature in webmethods.
Now, I have selected the SPwithSignature. In the call tab, I have selected the Schema Name and the Procedure Name.
It is giving the inputs and output parameters by itself.
The output parameter SQL Type is REF CURSOR. JDBC Type is ORACLECURSOR. Output Field Type is Document.
Till here, it is generating by itself. Now, In the ResultSet Tab, What should i give? I have mentioned resultset index 1 as CSR.
and in the bottom of it, I mentioned the resultset Name and JDBC Type as ORACLECURSOR. And it is setting the output type as java.lang.Object.
After that…When I see in the Input/Output tab, The input fields are strings and in the Output. There is a CSR Doc list, under it CSR is a Object.
When I run the SP, I am not getting any data back.
Please assist me.