Forum Discussion

RuanAlesi's avatar
RuanAlesi
New Contributor
4 years ago
Solved

StoredProcedure returns 'Unassigned'

After SP execution, the value retorned is just 'Unassigned'. I can see in Oracle that the procedure run with no problem, but the TestComplete command "procedureObj.Parameters.Items(5).Value" returns just 'Unassigned' when should returned 'OK', as like Oracle run. I'm using this:

procedureObj.Parameters.AddParameter();
procedureObj.Parameters.Items(5).name := 'RESULT';
procedureObj.Parameters.Items(5).DataType := ftString;
procedureObj.Parameters.Items(5).Direction := pdReturnValue;
procedureObj.Parameters.Items(5).Value := nil;

 

PS: DB Oracle 10, but ODBC connection Oracle 12.

  • RuanAlesi Did you manage to solve this?

    If not, I would suggest looking into the fact that you have different versions of a DB and a driver. This is a place to start the investigation!