cancel
Showing results for 
Search instead for 
Did you mean: 

StoredProcedure returns 'Unassigned'

SOLVED
RuanAlesi
New Contributor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
sonya_m
Community Manager

Re: StoredProcedure returns 'Unassigned'

@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!


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

2 REPLIES 2
sonya_m
Community Manager

Re: StoredProcedure returns 'Unassigned'

Hi Community! Any suggestions?

 

@Marsha_R @AlexKaras @cunderw @BenoitB @tristaanogre 


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
sonya_m
Community Manager

Re: StoredProcedure returns 'Unassigned'

@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!


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors