OCI-62835
The application %0!s is still being used by %1!s and cannot be dropped. Stop all programs that are using this application and retry the drop procedure.
Cause
There were one or more programs still using the application with either an uncommitted DBMS_KAFKA.UPDATE_OFFSET call or a global temporary table with pending inserts.
Action
Commit or roll back the pending transactions. Alternatively, shut down the programs that are accessing the application.