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 execute sql() routine of JJUPIN to save data in database

eric anier2

hi,

I have a procedure in oracle db which insert new data on a custom table and a commit at the end. Calling this procedure directly from my db tool(toad) it works fine.

But using JJUPIN sql() routine in a SIL script and calling it from SIL RUNNER Gadget, it doesnt work.

Is it possible to execute insert statement with sql() routine from Sil Runner Gadget?

sqlDo = "execute CUSTOM_PKG.INSERTDATA('test')";

sqlResult = sql("JiraDB", sqlDo);

I have been using sql() routine and Sil Runner Gadget successfully many times but just querying data from external table.

Regards,

Accepted answers

Błażej O_

OK, how about trying such script?:

string param1 = "'test'";
string sqlDo = "begin CUSTOM_PKG.INSERTDATA("+param1+"); end;";
string[] sqlResult = sql("JiraDB", sqlDo);

All comments

Silviu Burcea

Hi Eric,

You have a procedure there. You have to use a different routine for that: https://confluence.kepler-rominfo.com/display/SIL30/sqlCallStoredProcedure. If you need out params, check the very similar routine designed for this task.

HTH,

Silviu

eric anier2

Hi Silviu, how do i do this in JJUPIN 2.6? Regards,

Alexandra Topoloaga

Hi Eric, The routine is available since JJUPIN 3.0. I suggest you to update to JJUPIN 3.0 since, in addition to bugfixes, we also added lots of features, including structures and error handling in SIL language. Alexandra

eric anier2

Hi Alexandra, We will upgrade but not yet this time, do we have any other way to execute a procedure from Sil Runner Gadget? a workaround perhaps? Regards,

Błażej O_

What type of data are your parameters?

You can try this way:

string param1 = "'test'";
string sqlDo = "execute CUSTOM_PKG.INSERTDATA("+param1+")";
string[] sqlResult = sql("JiraDB", sqlDo);

eric anier2

Hi Blazej, I even tried a procedure without parameter, just directly insert and commit, it just doesnt work. Probably need to upgrade for this routine sqlCallStoredProcedure. Regards,

Błażej O_

Damn, maybe that's because Oracle handles it differently. We use above approach a lot in MS SQL and it works OK. Are you absolutely sure, that db user used in the JNDI source have permission to execute procedures and/or write data?

eric anier2

yup, user used on JNDI/DB Tool is the same, and it works when using DB Tool.

Błażej O_

OK, how about trying such script?:

string param1 = "'test'";
string sqlDo = "begin CUSTOM_PKG.INSERTDATA("+param1+"); end;";
string[] sqlResult = sql("JiraDB", sqlDo);

Welcome!

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

Quick Links

Find more posts tagged with

jira

power-scripts

addon-com.keplerrominfo.jira.plugins.jjupin