ADO.CreateADOStoredProc(): cant return not numeric value
Hi! Try to run Oracle stored procedure in TestComplete code: PROCEDURE TEST_PROCEDURE(IN_ID IN INT, OUT_ID OUT INT, OUT_ID1 OUT VARCHAR2) IS BEGIN SELECT 1, '2' INTO OUT_ID, OUT_ID1 FROM DUAL; END TEST_PROCEDURE; JS code: var SProc; SProc = ADO.CreateADOStoredProc(); SProc.ConnectionString="DRIVER=...bla-bla-bla"; SProc.ProcedureName = "SHS_TEST_PKG.TEST_PROCEDURE"; // IN parameters SProc.Parameters.CreateParameter("IN_ID", adInteger, adParamInput, 0, 21); // OUT parameters SProc.Parameters.CreateParameter("OUT_ID", DB.adInteger, adParamOutput, 0, 0); SProc.Parameters.CreateParameter("OUT_ID1", DB.adInteger, adParamOutput, 0, 0); SProc.ExecProc(); Log.Message("out1="+ SProc.Parameters.ParamByName("OUT_ID").Value+" out2=" + SProc.Parameters.ParamByName("OUT_ID1").Value); ////result out1=1 out2=2 Result OK, while out value is numeric or may be converted to numeric! But, when type of out value = varchar, "test 2" for example, sql - SELECT 1, 'test 2' INTO OUT_ID, OUT_ID1 FROM DUAL; and JS code for this - SProc.Parameters.CreateParameter("OUT_ID", DB.adInteger, adParamOutput, 0, 0); SProc.Parameters.CreateParameter("OUT_ID1", DB.adChar, adParamOutput, 0, 0); no result with error - "Неправильно определен объект Parameter. Предоставлены несовместимые или неполные сведения"Solved1.3KViews0likes4CommentsTestExecute interactive session fails when window is minimised
Hello, I am running TestComplete 14.60 and TestExecute 14.72 on W10. My project suite is stored in an onprem ADO Git repo and feeds into an ADO build pipeline. The tests execute and report normally on the 3 Test Agents I have configured in the test pool. I currently manually open a Remote Desktop Connection (RDC) , logon to each machine and start the agent and TestExecute as Admin before launching the tests. The tests will only run if the rdc windows are open (maximised or windowed). They fail if I run the pipeline with the RDC windows minimised. How can I avoid having this constraint. Thanks, JamesSolved641Views0likes1Comment
