Flow designer - jdbc step - exec stored procedure throws error

[Faizan9]

Hi

Looking for a solution/ answer for this scenario.

I have a jdbc step on flow designer where i'm putting in a command to execute a stored procedure on SQL server database as below:

Exec dbo.stored_procedure_name @param1 = 'x', @param2 = 'y'

When i test the jdbc step i get this error message: Given SQL statement is not allowed to be executed at this time.

I have put 'exec' as an allowed value on the mid server property: mid.property.jdbc_operations value: exec,select,update,insert,delete,show,create,describe

I'm wondering if its not supported by ServiceNow.

There's a stored procedure call on jdbc activity in worklow however.

Any help on this is appreciated.

[Brian Bouchard]

I don't have any experience with the jdbc step in Flow Designer, but wondered if you saw this KnowlegeBase article:

Custom workflow activity JDBC

[Faizan9]

Yes, that's the property i have already updated with 'exec' on it.

That change didn't fix the problem.

[vibhor_dwivedi]

Hi Faizan,

Did it work for you?

The documentation says By default, you can run the following SQL operations.

• SELECT
• INSERT
• UPDATE
• DELETE
• SHOW
• DESCRIBE

I am also planning to use this step action to execute stored procedure.

[P-Rudenko-SN]

@vibhor.dwivedi @Faizan were you guys finally able to solve the issue?

I'm having the same one.