Forum Discussion

RuanAlesi's avatar
RuanAlesi
New Contributor
5 years ago

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.

  • sonya_m's avatar
    sonya_m
    5 years ago

    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!