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 F...
(!) Find solution in old topic - https://community.smartbear.com/t5/TestComplete-General-Discussions/CreateADOStoredProc-and-a-adVarChar-Parameter/td-p/52777
- When using ADO.CreateADOStoredProc, use the VCL data type constants:
http://docwiki.embarcadero.com/Libraries/en/Data.Win.ADODB.TDataTypeSo,
SProc = ADO.CreateADOStoredProc();
//worked!
SProc.Parameters.CreateParameter("OUT_ID1", ftFixedChar, adParamOutput, 1000, null);
//NOT worked!
//SProc.Parameters.CreateParameter("OUT_ID1", adVarChar, adParamOutput, 1000, null);
