Collections:
Run-Away Recursive Calls in Oracle
What Happens If Recursive Calls Get Out of Control in Oracle?
✍: FYIcenter.com
What happens if your code has bug on recursive procedure calls, which causes an infinite number nested procedure calls? The answer is not so good. Oracle server seems to offer no protection calling stack limit. The script below shows you a badly coded recursive procedure. If you run it on an Oracle 10g XE server on Windows, your server will out of control and keep using virtual memory to satisfy the growing calling stack. You have to reboot your server to control back.
SQL> CREATE OR REPLACE PROCEDURE STACK_TEST AS 2 --Warning: do not run this procedure on your server 3 PROCEDURE STACK AS 4 BEGIN 5 STACK; 6 END; 7 BEGIN 8 STACK; 9 END; 10 / SQL> EXECUTE STACK_TEST; (your server keep running with 100% CPU and memory usage)
⇒ Define Variables before Procedures and Functions in Oracle
⇐ Call Procedure or Function Recursively in Oracle
2018-03-18, 1553🔥, 0💬
Popular Posts:
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...