Oracle PL/SQL EXEC Keyword Stops Script From Running

We use the keyword `EXEC` or `EXECUTE` extensively throughout our code base. I am trialing using DataGrip and so far I really like it.The one thing that stops me currently is the inability to run any script that has these two keywords.

I get:
[42000][900]
    ORA-00900: invalid SQL statement
    https://docs.oracle.com/error-help/db/ora-00900/
Position: 0

 

From what I can tell Oracle SQL Developer is actually automatically changing `EXEC function()` to 

``` 
Begin

function();

end;

/
```
 Does anyone know if it's possible to do something similar with DataGrip? Changing all the instances of `EXEC` in our shared code base is not an option. I have tried looking this issue up, but it's not coming up with anything so far. Cheers.

0
Exec and Execute are SQL*Plus-style shortcuts, not standard Oracle SQL. The IDE doesn't have the means to reinterpret these commands and translate them into pure Oracle SQL. If editing the code is not an option, you may want to use live templates to replace those fragments as a workaround. Please see below for more details:

https://www.jetbrains.com/help/datagrip/using-live-templates.html
0

请先登录再写评论。