How to execute Oracle stored procedure from JDBC activity designer?

sahanabhat · ‎04-13-2017

Hi All ,

When we tried to execute the simple stored procedure we received the following error. What may be causing it?

at oracle.jdbc.driver.OracleParameterMetaData.getParameterMode(OracleParameterMetaData.java:262)

at com.snc.commons.jdbc.StoredProcedure.generateProcedureParameters(StoredProcedure.java:139)

at com.snc.commons.jdbc.StoredProcedure.execute(StoredProcedure.java:43)

at com.service_now.mid.probe.JDBCOrchestrationProbe.doStoredProcedure(JDBCOrchestrationProbe.java:314)

at com.service_now.mid.probe.JDBCOrchestrationProbe.probe(JDBCOrchestrationProbe.java:132)

at com.service_now.mid.probe.AProbe.process(AProbe.java:81)

at com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:123)

at com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745

arabeau · ‎12-19-2018

Hi sahanabhat,

did you ever figure this out or find another way to call oracle stored procedures from servicenow workflow activities/scripts?

sahanabhat · ‎03-19-2019

Hi arabeau,

We called Stored procedure using the powershell script and we called that powershell script using the Servicenow Orchestration - powershell activity.

Thanks and Regards,

Sahana

sowmyaprabhakar · ‎08-31-2023

Hi I am looking for a similar use case.

Can you please share the steps for reference.

Appreciate your help.

Thanks,

Sowmya