[cx-oracle-users] How to induce "ORA-03114: Not Connected to Oracle"?

[Piotr D. <public.2019@p.dobrogost.net>]

Hi all!

How can I induce ORA-03114 in cx_Oracle for the purpose of testing
application behavior?

I tried blocking network traffic after the connection has been established
but this resulted in cx_Oracle (I guess) waiting for a response from the
server and after a couple of minutes I gave up. Strangely it seems like
there are no timeouts in this situation.

I guess inducing ORA-03114 might require closing all connections (I'm using
connection pool in SQLAlchemy) and then somehow preventing new ones from
establishing?

Best regards,
Piotr Dobrogost