Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Jetbrains Datagrip / PHPStorm how to execute an oracle Procedure?

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

like image 443
Rodrigo Avatar asked Jan 04 '16 17:01

Rodrigo


People also ask

How do I run a query on DataGrip?

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.

How do I run a stored procedure in IntelliJ?

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.

Is DataGrip included in PhpStorm?

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.


1 Answers

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');
like image 104
Vadzim Avatar answered Oct 17 '22 11:10

Vadzim