Hello everyone,
My application activates procedure A that activates procedure B
Stored procedure B performs a tables' update and its
last statement is:
Select field1, field2,..
From TABLE_NAME
Where condition
Namely, in the end of the procedure a results set is retrieved to
the application
When procedure B is activated directly, there is not a problem.
However when the application activates procedure A, that calls to
procedure B, it encounters problems, because it needs only procedure
A's results sets.
Of course to overcome this problem , I can add an additional parameter
to procedure B, that is null by default and the results set return is
performed , only if it has a non null value.
Is there a better way in Sybase to prevent returning results set by
procedure B without introducing a special change in it.
If the answer is positive, I will be grateful to get an example code
and the number of the Sybase version that enables that.
Thank you in advance,
Amos
|
