How to apply changes after editing a stored procedure
I see PhpStorm 5 allows for editing of stored procedures in the database.
After editing the stored procedure I couldn't find any way of applying the changes I made.
I then ended up making the changes in MySQLWorkbench, when I tried to synchronize the stored procedure in PhpStorm it remained unchanged.
I'm not sure if these 2 issues are related, it's connecting to the database successfully.
Please sign in to leave a comment.
Please check if issues are reproducible in the latest release: http://www.jetbrains.com/phpstorm/download/
I have checked and I have the latest version installed.
Do you know if it's possible to update a stored procedure from phpStorm? Has anyone done it can direct me on how to go about applying the changes.
I can verify the issue still exists with IntelliJ IDEA 2017.1.4 and an Oracle database.
The only reliable update strategy seems to be restarting IntelliJ IDEA.
I am using IntelliJ IDEA Ultimate 2017.3 on a MacBook Pro. I had no problem editing Oracle stored procedures and applying the changes (using CREATE OR REPLACE...). However, if someone else made a change, I could not see those changes. I tried all combinations of synchronising, restarting and forgetting cached schemas but to no avail.
I did manage to get this working in the end - I did the following:
It may be that it's not necessary to go to these lengths (e.g. perhaps I only needed to disable Auto sync) but there is definitely something not quite right about the synchronise process (or schema caching) that JetBrains need to have a look at.
@Avenak Consulting
It's better to report this observation at http://youtrack.jetbrains.com/issues/DBE#newissue=yes providing some details for developers to actually look into. They are rarely checking forums unless asked directly by someone.