cancel
Showing results for 
Search instead for 
Did you mean: 

StoredProcedure returns 'Unassigned'

SOLVED
Highlighted
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
Highlighted
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
Highlighted
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. ⬇️⬇️⬇️
Highlighted
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
Script Wanted
A new challenge is here!

Create a function to drag one element to another for the TechCorner tag!

Will you dare to take the challenge?


Scripts created in July:
- Passing custom command-line arguments as a test parameter
Top Kudoed Authors