Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ADODB command object - syntax error on EXECUTE with a return value on stored procedure
The stored procedure I am trying to execute is not saved in Database (SQL Developer). I am passing the stored procedure in the external excel sheet, then fetching the stored procedure in uft by making connection with the excel sheet. strProcedure =... -
ADODB command object - syntax error on EXECUTE with a return value on stored procedure
I have tried executing it the way you have explained, I am still getting the same error. I have attached the error screenshot. Is it necessary to have SQL procedure stored in Database with some name... -
ADODB command object - syntax error on EXECUTE with a return value on stored procedure
One more query: Is it necessary to have SQL procedure stored in Database to run it through UFT? -
ADODB command object - syntax error on EXECUTE with a return value on stored procedure
Hey, Connection in my code is a variable name, earlier I was trying with ADODB.Connection but it was not working that time. After research I got to know that there is another method to run stored procedures i.e. ADODB.Command Recordset I am not using because the procedure that I am using is not... -
QCUtil.CurrentTestSet not working
Hey strongm, Thanks for your reply. ALM & UFT are already connected, the test case that I am trying to execute is already present in the ALM, I have opened the test case through ALM in UFT. I am getting the error at Line 2: Line 1: Set ObjCurrentTest = QCUtil.CurrentTestSet Line 2: Dim... -
QCUtil.CurrentTestSet not working
Hi All, I am trying to get test set name, folder name & other properties using QCUtil.CurrentTestset but UFT is not identifying it. No methods are visible for this object. I am getting a vbscript runtime error "424 object required". I have tried to clear all the cache, temp files, restarted... -
ADODB command object - syntax error on EXECUTE with a return value on stored procedure
My code is: _____________________________________________________________________________________________________________ Public Function gn_runSQLProcedure(strProcedure) Dim connectionString: connectionString = "DRIVER={Microsoft ODBC for Oracle}... -
ADODB command object - syntax error on EXECUTE with a return value on stored procedure
thread329-1688177 I am facing exactly same issue as mentioned in the above thread, can someone please help me here. Help is much needed. Thank You in advance.
