What is recursive stored procedure?

[Eddie]

Hi all, I would like to know kindly what is recursive stored procedure? This is urgent, please give me your answer quickly.

[Aarav]

A stored procedure can be recursive, referencing itself directly or indirectly. That is, the stored procedure body can contain a CALL statement invoking the procedure being defined. Such CALL statements can also be nested.