ContributionsMost RecentMost LikesSolutionsRe: db2 stored procedure with decimal datatype gives "CLI0111E Numeric value out of range SQLSTATE=22003 The issue is only happening when i invoke it from Test complete, it is doesnot occur when i invoke that stored procedure direclty from the DB itself or our applicaiton. 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; Re: JScript runtime error. ORA-12541: TNS:no listener added the env variable ORACLE_HOME , i had windows 10 installed on it and forgot about this PATH variable, this was working before the upgrade to windows 10. It started working once the path is added. thanks again Re: 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"" JScript 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) SolvedRe: use filelist across projects groovy scripts I was able to solve this. and had the scripts to work. thank you use 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? Is 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. Thanks Re: execute oracle stored procedure with refcursor output parameter in testcomplete I found the solution for this and resolved this. Had to change the provide to ORAOLEDB provider instead of MSDORA. Thanks execute 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. Solved