New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
Calling a Oracle Stored Procedure from QTP.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Calling a Oracle Stored Procedure from QTP.
geethwind Offline
Junior Member
**
Posts: 25
Threads: 11
Joined: Jun 2009
Reputation: 0
#2
Not Solved 07-21-2009, 04:17 AM
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,
Find
Reply


Messages In This Thread
RE: Calling a Oracle Stored Procedure from QTP. - by geethwind - 07-21-2009, 04:17 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  calling QTP script from one to another krishnas.tester 3 6,724 11-12-2014, 10:32 AM
Last Post: vinod123
  Request Help | Usage of Oracle Add-In for Oracle SQL Developer Nasir Ahmed 3 3,542 06-18-2014, 04:28 PM
Last Post: vinod123
  Connection to oracle using JDBC and QTP dileep45 0 3,444 07-30-2013, 06:39 PM
Last Post: dileep45
  Need to put a value in editbox and the value is stored in a variable anushreebehura 2 2,660 05-10-2013, 03:03 PM
Last Post: SweetyChowdhury
  calling stored procedure from Oracle borisk 3 6,446 03-19-2013, 12:41 PM
Last Post: gaveyom

Forum Jump:


Users browsing this thread: 2 Guest(s)