Which data type can be used only on OUTPUT parameters of the stored proceduer?

Which data type can be used only on OUTPUT parameters of the
stored proceduer?

Question Posted / mohanakrishnan a.c

2 Answers
4754 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which data type can be used only on OUTPUT parameters of the stored proceduer?..

Answer / madhusudan singh kushwah

Stored procedure return data In 4 ways. which are as follow:

1)output Prameter:-which can return either data(such As
integer or char value) or a cursor variable(cursors are
result sets that can be retreived 1 row at a time).

2)return Codes:-Which are always an Integer Value.

3)A result set for each statement contain in Stored
procedure or any other Stored procedures called by the
Stored Procedure.

4)A global cursor that can refrenced outside the procedure.

Is This Answer Correct ?

4 Yes

1 No

Which data type can be used only on OUTPUT parameters of the stored proceduer?..

Answer / jothi

Cursor

Is This Answer Correct ?

1 Yes

1 No

Post New Answer