You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!