why is OIC freezing up when invoking a stored procedure in an integration?
Summary:
In the oracle database adapter endpoint configuration wizard, I first provide a name, next select the schema, next select the package, next select the procedure. Then OIC freezes ups, meaning the only option is to leave the page/exit the integration. The procedure that causes the issue is a very simple procedure (deletes rows from a few tables in the database). All other procedures from the package can be selected without freezing up
Content (required):
In the oracle database adapter endpoint configuration wizard, I first provide a name, next select the schema, next select the package, next select the procedure. Then OIC freezes ups, meaning the only option is to leave the page/exit the integration. The procedure that causes the issue is a very simple procedure (deletes rows from a few tables in the database). All other procedures from the package can be selected without freezing up. The procedure can be called within the database without error/issue. This is a major BLOCKING issue because the integration cannot be completed until we are able to