Need Help in Oracle Stored procedure execution using JDBC step

[yaduvanshi_pankaj]

Hi All, 

 

Greetings!

 

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.")   

                             Direction-Output    

 

I am working with Devtest 9.0

[Marcy Nunns]

Have you reviewed the documentation?

https://docops.ca.com/devtest-solutions/9-0/en/reference/test-step-descriptions/other-transaction-steps/sql-database-execution-jdbc

https://docops.ca.com/devtest-solutions/9-0/en/reference/test-step-descriptions/other-transaction-steps/sql-database-execution-jdbc-with-asset

[yaduvanshi_pankaj]

Yes i have checked above links but not helpful.

[Vish G]

Hi,

      Create a DevTest property and pass it as "Out" parameter in your SP.The property will hold the output value.

Thanks,

Vish

[yaduvanshi_pankaj]

Hi Vish, 

 

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"?

[Vish G]

Hi,

     Can you post  the sample query you are trying to execute?

Thanks,

Vish

[yaduvanshi_pankaj]

Here is sample for your reference, 

Stored procedure:

begin
testuser.GetInteractiont(:1,:2,:3);
end;

 

Parameters definations,
1-->in-->String
2-->in-->String
3-->Out-->sys_refcursor;

[Vish G]

Hi,

Stored procedure:

DECLARE
Outputvariable Datatype;

begin 
testuser.GetInteractiont(:1,:2,:Outputvariable);
end;

 

Parameters definations, 
1-->in-->String
2-->in-->String
Outputvariable-->Out-->sys_refcursor;

Thanks,

Vish

[yaduvanshi_pankaj]

Hi Vish, 

 

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? 

[Vish G]

Hi,

      It will be available as a DevTest property.

                            Thanks,

Vish

[yaduvanshi_pankaj]

Thanks Vish for your response, but there is no way to implement above said, 

I have done it using Java