hb
Occasional Contributor
Joined 10 years ago
User Profile
User Widgets
Contributions
db2 stored procedure with decimal datatype gives "CLI0111E Numeric value out of range SQLSTATE=22003
I am executing a db2 stored procedure with decimal(10) as the parameter type, i tried with both adDecimal and adNumeric with size as well, still get the same issue, same procedure call in Oracle and MSSQL works fine as the datatype there is integer. var prm4 = cmdObj.CreateParameter("mc_id", adDecimal, adParamInput); cmdObj.Parameters.Append(prm4); prm1.size=10; prm4.Value=mc_id;1.3KViews0likes4CommentsRe: JScript runtime error. ORA-12541: TNS:no listener
Hi Thank you for the response, my bad i did not include the test complete version before itself, i am using the 32 bit i have my shortcut referring to the below location ""C:\Program Files (x86)\SmartBear\TestComplete 12\Bin\TestComplete.exe""2.3KViews0likes1CommentJScript runtime error. ORA-12541: TNS:no listener
I have installed the new oracle 12 client on the machine (32 bit) , i have Excel-connecting to the oracle db as well, on the same machine, testcomplete keeps giving "JScript runtime error. ORA-12541: TNS:no listener Error location: Unit: "PWTestEngine\PWTestEngineJS\Script\TestActionsHelper" Line: 1185 Column: 3. JScript runtime error. ORA-12541: TNS:no listener " error From the same machine i have tried the excel macro and also visual studio both are using the same oraoledb driver and ADODB from test complete var recset = Sys.OleObject("ADODB.recordset"); var conObj = Sys.OleObject("ADODB.Connection"); var str1 = "Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST="; var str2 = dbname + ")(PORT=" + dbport + ")))(CONNECT_DATA=(SERVICE_NAME= " + dbsid + ")(SERVER=DEDICATED)));"; var str3 = "User Id= " + dbuser + ";Password=" + dbpwd + ";"; var conString = str1 + str2+ str3; conObj.Open(conString); return conObj; below is the one from macro str1 = "Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" str2 = dbName & ")(PORT=" & dbPort & ")))(CONNECT_DATA=(SERVICE_NAME= " & dbSid & ")(SERVER=DEDICATED)));" str3 = "User Id= " & dbUser & ";Password=" & dbPwd & ";" connectionString = str1 + str2 + str3 '--- Open the above connection string. Con.Open (connectionString)Solved2.5KViews0likes3Commentsuse filelist across projects groovy scripts
I have two projects, groovyscriptsLibrary and second project is uploadbinding, there is a step in first project that reads the list of xml files and sets it into the context. I am calling the step as part of second project. and want to use that filelist fileListScript:- project1 def fileList = [] def requestFileLocation = context.expand( '${#Global#RequestFilePath}' ) new File(requestFileLocation).eachFile { f -> if (f.isFile()&& f.name.endsWith('.xml')) { def filename = f.name[0..-1] fileList.add(filename) log.info filename } } context.put('fileList',fileList) second script in project2; def requestFileLocation = context.expand( '${#Global#RequestFilePath}' ) log.info(requestFileLocation) File file = new File(requestFileLocation +"\\"+ context.get('fileList').last()) context.put('ffile',file) filelist object is coming as null. I have tried to call the filelistscript from project2 as well the object is still null. is there a way i could use this across projects?743Views0likes1CommentIs there a way to convert scripts from IBM RFT to test complete 12?
Our application is flex based and the automated scripts are currently written using IBM RFT, is there a way to convert these scripts automatically to testcomplete? on another note, the application is being converted from flex to HTLM5 shortly, we are also looking to see if we have a way to convert these as well. Thanks747Views0likes1Commentexecute oracle stored procedure with refcursor output parameter in testcomplete
I have to execute an oracle stored procedure from test complete that returns a refcursor, I tried different ways with parameter object and also using the record set My stored procedure exm create or replace PROCEDURE TESTPROC ( retCur OUT GLOBALPKG.RCT1) AS BEGIN open retCur for SELECT mc_id, ct_id,ct_type from authors where id=20210; END TESTPROC; In sqldeveloper, I execute it as below var c refcursor; execute testproc (:c); print c; If I use the below, it says parameter not defined. var recset = Sys.OleObject("ADODB.recordset"); var conObj = Sys.OleObject("ADODB.Connection"); var cmdObj = Sys.OleObject("ADODB.Command"); var conString = "Driver={Microsoft ODBC for Oracle};Server=db1:1521/utdb1; Uid=PW11;Pwd=o"; conObj.Open(conString); cmdObj.ActiveConnection= conObj; cmdObj.CommandText="TESTPROC"; cmdObj.CommandType= 4 //adCmdStoredProc; recset = cmdObj.Execute(); IF I set up the parameter object, it says parameter not supported var conObj = Sys.OleObject("ADODB.Connection"); var cmdObj = Sys.OleObject("ADODB.Command"); var conString = "Driver={Microsoft ODBC for Oracle};Server=db1:1521/utdb1; Uid=PW11;Pwd=o"; conObj.Open(conString); cmdObj.ActiveConnection= conObj; cmdObj.CommandText="TESTPROC"; cmdObj.CommandType= 4 //adCmdStoredProc; var Prm = cmdObj.CreateParameter("MyParam", adUserDefined, adParamOutput); cmdObj.Parameters.Append(Prm); cmdObj.Execute(); Can you please suggest if there is a way to get around this.Solved6.8KViews0likes2Comments