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.
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.
Short answer: no workaround Long answer: There is https://confluence.kepler-rominfo.com/display/SIL/system routine, if you can manage to invoke an sql command using it, you have the solution for your problem.
This is the error log, any idea? 2015-08-13 18:54:14,894 pool-15-thread-1 ERROR eric1000 582x2403x1 jxc0go 192.168.10.10 /rest/keplerrominfo/jjupin/latest/rungadget/run [commons.sil.routines.SQLRoutine] Could not execute SQL >>execute PKG.INSERTDATA('Test')<< on database JiraDB. java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot