This content has been marked as final. Show 2 replies
As an update:
We have done a trace on the session, and what we found that internally it was hanging when it was trying to delete from a table called "WB_RT_NOTIFY_QUEUE_TAB".
I should tell you that we are not trying to delete anything from that table in our code, but it is something the OWB code itself is doing.
Any help is appreciated.
Check for any wait events for a lock.
Try restarting the database, potentially releasing the lock.
Try creating a process flow and execute that using sqlplus_exec_template.sql and see if that succeeds.
Let us know if any of this works.