Oracle SQL parameters like in Developer

Hi,


First of all thank you for your time, it is really appreciated.

I have been using PyCharm for a long time and due to the good quality of Jetbrains products I was switching from Oracle SQL Developer to Datagrip.

I work with an ERP database in Oracle and in my queries I use a lot of input parameters where the user can specify the parameter. Usually, in our ERP and in SQL Developer works properly, we use the parameters like '&PARAMETER_NAME'.

I configure Datagrip to be able to use the same parameter and it works but in the parameter window, all of them are called '_' which is a bit confusing if you do not know exactly the order of them. I attach an image with it:

 

It works perfect but as you can see, the parameters in the input window show as '_' without the name of those parameters. My parameter config is the following one:

 

 

I am almost 100% sure I am doing it wrong. It is important that those parameters are defined like this because is how ERP works.

Thanks and kind regards,

Endika.

 

1
4 comments
Hello,

Thank you for contacting us.

This seems to be a default value that's being displayed when using substitute inside SQL strings:

https://www.jetbrains.com/help/datagrip/settings-tools-database-user-parameters.html

I'll need some time to figure out if we can add the predicate name instead of '_' using regular expression templates.
0

Thanks for the reply! For small queries it is not a problem but when the queries are considerable large and there are multiple parameters it can be a bit tricky.

Kind regards!

0

Thank you for being patient.

We investigated and found out that it happens when using the Like operator, but it doesn't occur with the equality operator in some cases. But this behavior is certainly our concern, and for this reason, we have created a bug report:

https://youtrack.jetbrains.com/issue/DBE-16985/Predicate-name-not-identified-when-using-custom-user-parameters

For further status updates on this issue, please follow the link above.

0

Thank you very much for your support!

0

Please sign in to leave a comment.