I an trying to execute a oracle stored procedure using Devtest JDBC step but facing problem, Need help in the same.
Execution of Stored procedure takes some inputs and provides output, So i Need to pass some parameters for the same,
I am able to locate all other parameter types but not sure how handle output parameter,
which has below data types,
Oracle Data type-> RefCursor
Data type --> Object
Value --> Null(when passing Empty value it is throwing error "Value at index 11 needs to be property
for OUT or INOUT mode.")
I am working with Devtest 9.0
Have you reviewed the documentation?
Yes i have checked above links but not helpful.
Create a DevTest property and pass it as "Out" parameter in your SP.The property will hold the output value.
Thanks for replying.
I have tried the same but it is responding with "wrong number or types of arguments in call" what should i select in type as it is returning "Oracle Data type-> RefCursor, Data type --> Object"?
Can you post the sample query you are trying to execute?
Here is sample for your reference,
Parameters definations, 1-->in-->String2-->in-->String3-->Out-->sys_refcursor;
Parameters definations, 1-->in-->String2-->in-->StringOutputvariable-->Out-->sys_refcursor;
I has tried this approach but not finding a way to print the output in Devtest,
How to get the Output from declared variable as part of Stored procedure?
It will be available as a DevTest property.
Thanks Vish for your response, but there is no way to implement above said,
I have done it using Java