Search

You need to put a ; at the end of your script.

I released another version to put it for you.

Enjoy.

Hello Fernando, 

thanks for answer. But I already put ";" after end of the line.

My current script is here 

"select * from kurallar;"

and temporary script file content is 

"select * from agito.kurallar;
exit;"

So the plugin puts the exit; line after the my line. And it has ";" as you realise.

I think there is another problem. Because it stuck on this line

"/home/oracle/app/oracle/product/11.2.0/dbhome_2/bin/sqlplus -L agito/agito@orcl @/tmp/temp-script-15112854694264350207600678930343.sql"

But when i call this line from linux console it works perfect.

When you run, do you use Jenkins user ?

Have you tried the new version yet ?

I have noticed sometimes hangs on Windows machines.

Hello,

I was using admin user of jenkins.

Yes I updated to new version. But it puts another ; after the end of script. So it's doubling the ; mark. 

I think I realise the problem. If i use a select statement in the script. It's not working. That means it can not read the query results from the output. But if there is no output it works.

So i tried a plsql script inside begin bla; bla; bla; end; it worked for me.

Bu it always returns success even script raises an execption.

I can't make the script failed. So every build finishes with success result. Bu i need failed result too. 

My goal is firstly deploy oracle scripts to the oracle db server. And if its success I'm gonna deploy java application to the weblogic.

I'm already using jenkins for java deployment but i want to put plsql deployment before java for a new level of continuous integration.

Thanks for help.

Sorry, if you depends on script result I can't help you because I only get the exit code from SQL*Plus.