Calling a Oracle Stored Procedure from QTP.

[geethwind]

Hi..

I have to call an Oracle Stored Procedure sitting in a package with parameters from QTP.

When i try to give the below code , the app is giving me error @
"cm.Parameters(0).Value = "ROUTE_ROLLOVER" " step. as item cannot be found in the collection corresponding to the requested name or ordinal.

and the parameters.count is returning "0".

How can i call a stored proc inside the package using QTP?

my code:
======

Code:

cm.CommandType = 4 ' Stored Procedures cm.CommandText = "P_CONFIG_SETTING.GetSetting" cm.Parameters.Refresh msgbox( cm.parameters.count) ' Pass input value. Assuming Stored Procedure requires 2 parameters cm.Parameters(0).Value = "ROUTE_ROLLOVER" cm.Parameters(1).Value = "TO_ADDRESS" ' Execute the stored procedure Set rs = cm.execute()

any pointers are highly appreciated.

Thanks,
Geetha

[geethwind]

I resolved the above error and getting a new one now.

Code:

Set cm.ActiveConnection = conn cm.CommandType = 4 cm.CommandText = "SDCF.P_CONFIG_SETTING.GetSetting" cm.Parameters.Append cm.CreateParameter("P1",129,1,20,"ROUTE_ROLLOVER") cm.Parameters.Append cm.CreateParameter("P2",129,1,20,"TO_ADDRESS")

cm.execute ' This line is giving an error GetSetting is not a procedure or undefined..

any pointers how to define the command text when giving the SP under a Oracle package?

TIA,

[geethwind]

Hi, the above error was occuring because the GetSetting is not a Stored Proc, it is a function.

I am able to call the functions successfully from QTP. But the problem is calling the stored proc which has the cursor parameter as OUT parameter.

Can anyone have done calling stored procs returning resultsets from QTP? any sample code is highly helpful.

[prasadsbrk]

Hi,

Can you tell me how to call Stored Procs in QTP with good example including exception handling

Thanks