Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to execute PL/SQL procedures from DataGrip

I am new to DataGrip IDE and I have some problems understanding it.

I am able to create a procedure in DataGrip and the output in the terminal shows procedure created, but when I want to execute the procedure with command execute p2 or exec p2 (p2 is procedure name) DataGrip shows error 'invalid SQL statement' or 'nothing to run'.

like image 534
Cyber Liebe Avatar asked Oct 29 '25 14:10

Cyber Liebe


2 Answers

So don't exec it. Proper way to do that is

begin
  p2;
end;
/

anyway.

like image 133
Littlefoot Avatar answered Oct 31 '25 04:10

Littlefoot


In DataGrip any procedure can be run via context menu.

enter image description here

like image 30
moscas Avatar answered Oct 31 '25 04:10

moscas



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!