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

execution of stored procedure does not return data

Received Response
47
Views
5
Comments

Summary:


Content (required):

I have an integration that connects to the DBCS database and runs a separate procedure. The DB procedure returns a cursor type field. When I run a test on the same database, the procedure if returns data. But when I run it from the integration it does not return data.

I have other integrations that do the same with other procedures and there is no problem.

I have already validated that the connection and assignment are correct but for some reason the OIC does not return data.

procedure invoked:

Result of executing the procedure inside the database:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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