can i write function in stored procedure and stored procedure in function and n

can i write function in stored procedure and stored
procedure in function and nested procedure.Give one example
for each question?

Question Posted / venukumar.coign

1 Answers
8314 Views
Cap Gemini, TCS, I also Faced
E-Mail Answers

can i write function in stored procedure and stored procedure in function and nested procedure.Give..

Answer / dba

You cannot define stored procedures (SP) or user-define
functions (UDF) in a nested fashion. However, you can
execute SPs and UDFs inside of stored procedures. The
nesting is limited to 32 levels deep (A calls B, which calls
C, etc). So if a recursive call is used (A calls A), you
must have some method of stopping before 32 levels is exceeded.

You can call SPs and UDFs from inside of a UDF, but this
ability is quite limited. If a SP has any side effect, it
cannot be called. So, the SP cannot be used to return any
values to the function.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer