Get the actual status of Oracle Stored Procedure which calls Insert SQL

Question

Hi,

In my logic app step, I am calling a Oracle execute stored procedure where the script adds records to a table based on parameters passed.

The records are not getting inserted in the table.

I would like to know how to add steps which can provide the status of the execution and catch any exception that arises.

Below is the output of the execution:

The output is showing the status as 200 and raw outputs show as :

Cache-Control

no-store, no-cache

Pragma

no-cache

Transfer-Encoding

chunked

Vary

Accept-Encoding

Set-Cookie

ARRAffinity= <.removed>

x-ms-request-id

437c0bbb-ade9-44c5-94bb-fc248d4a79a6

Strict-Transport-Security

max-age=31536000; includeSubDomains

X-Content-Type-Options

nosniff

X-Frame-Options

DENY

x-ms-connection-gateway-object-id

ce910643-6bbe-405b-b0f6-394ed88da4a1

Timing-Allow-Origin

*

x-ms-apihub-cached-response

false

x-ms-apihub-obo

false

Date

Tue, 07 Feb 2023 11:14:17 GMT

Content-Type

application/json; charset=utf-8

Expires

-1

---

And the Body is :

{
  "OutputParameters": {},
  "ResultSets": {}
}

Answer 1

@Srinivas Mehenderker Nath Thanks for reaching out. If there are any errors thrown while executing the store procedure, then the error would be through by the connector, and you should see other status code apart from 200. The call does wait for the store procedure to get executed successfully within the time limit else throw timeout exception or the exception thrown while executing the store procedure. There are few limitations as documented here. Just in case if you are catching the error and returning the value then the return value or out value is not supported as documented.

I will suggest you to execute the store procedure with the same input as per your successfully executed run by navigating to run history and verify if your store procedure executes successfully or throws error with the same input as passed from logic app.