I'm trying both softwares using thin client (jdbc). My database is oracle (v9 and v11g). The problem is that I can't find a way to execute a procedure. I have try:
execute schema.package.procedure('lorem', :a); -- Like TOAD
execute schema.package.procedure('lorem');
execute package.procedure('lorem');
execute package.procedure('lorem', :a); -- Also Like TOAD
Nothing works. Always the same message: [2016-01-04 12:40:12] [42000][900] ORA-00900: invalid SQL statement
Right-click a data source and select New | Query Console. Click a data source, press Alt+Insert , and select Query Console. Click a data source, press Ctrl+Shift+F10 , and select New Query Console.
Run stored proceduresRight-click a stored function that you want to execute. In the Execute Routine window, type all the necessary parameter values, and click OK.
Does DataGrip repeat the functionality of the database tools in other JetBrains IDEs? Yes. All of DataGrip's features are also available in other IDEs from JetBrains like IntelliJ IDEA, PhpStorm, PyCharm, RubyMine, as well as the upcoming Rider and Gogland.
DataGrip allows to execute stored procedure without parameters in current schema like this:
call some_proc();
Here is how to call proc with params from other schema:
call schema.package.procedure('params');
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