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'.
So don't exec it. Proper way to do that is
begin
p2;
end;
/
anyway.
In DataGrip any procedure can be run via context menu.

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