Running oracle sp from JIRA

[Christian Jaya]

Good Morning

I need some help, i try ti run an oracle store procedure from JIRA, for the moment use Power Scripts for JIRA

please help, is so much urgent

thank you so much for your answer

[Alexey Matveev]

Hello,

You need to configure the datasource to your Oracle database. You can read more here about it

https://confluence.cprime.io/display/SIL/SQL+Data+Sources

Then you can call the stored procedure. You can read more here:

https://confluence.cprime.io/display/SIL/sqlCallStoredProcedure

[Christian Jaya]

thanks for your answer, so helpful, I did exactly what it says in the documentation, but i have this error

An unknown exception occured executing Validator com.atlassian.jira.workflow.SkippableValidator@39eb617e: root cause: Exception while executing SIL program >>prueba_1.sil<<: SQL execution failed, check log for details.|0

Please can you help me, or maybe you have a practical example of this topic

[Alexey Matveev]

have a look in the atlassian-jira.log for the errors.