nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to create a JIRA issue using PLSQL code. Whre JIRA is remote server?

Rudrama Devi

We have a requirement to create an issue through PLSQL when a concurrent Job completed in oracle apps.

I am new to using REST APIS of JIRA. So some one could provide me the details oe existing code to use how to creata a JIRA issue through PLSQL code using BAsic authentication?

Accepted answers

Lenin Raj

Hi @Rudrama Devi

I found some references online about how to call REST APIs via PL/SQL: https://technology.amis.nl/2015/05/11/invoke-a-rest-service-from-plsql-make-an-http-post-request-using-utl_http-in-oracle-database-11g-xe/

This is the documentation for creating a new issue: https://developer.atlassian.com/cloud/jira/platform/rest/v3/?utm_source=%2Fcloud%2Fjira%2Fplatform%2Frest%2F&utm_medium=302#api-rest-api-3-issue-post

All comments

Lenin Raj

Hi @Rudrama Devi

Rudrama Devi

Thanks Raj for the documents. Really they helpful to understand basic concepts, but need clarifications on below.

1) Actually when we try to connect to Webservice through REST API using utl_http package we require a certificate to be attached with it.. So is this certificate required for JIRA services also?

2) I could see sample code to create an issue in n Curl,node.js,Java,Python and PHO languages..Can we use any of this code directly in PLSQL?

3) Is there any sample Java code which can create an issue in JIRA that will be called through PLSQL:

Any how thanks much for the documents.

Ozan_KURT

Hi @Rudrama Devi,

I need to create an issue through PLSQL too. I tried UTL_HTTP but cannot get result. Did you get some progress? If so, could you help me? h.ozankurt@gmail.com

Ozan_KURT

@Rudrama Devi Hi, did you get any progress? I am trying to same thing. Could you help me?

Rudrama Devi

Hi Ozan,

Based on our analysis we found 2 solutions to integrate Oracle EBS with JIRA

Option 1: Intrgrate Oracle EBS with JIRA through e-mail handler. This is simple. We have to create shared outlook email box and attch it to JIRA project.This is working fine.

Oprion 2: Through PLSQL code .. Our progress on this is

We tried sample code and it was failing due to wrong certitificate. So currently we are trying to get correct .pks certificate with ,immediate server details,private key etc. Hoping this will work beacuse we are only getting getting invalid certificate error.Will update you once we tested with new certificate.

ChandlerBing

@Ozan_KURT have you find any solution , I am trying to do same thing

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

script

oracle