Oracle editing package body -> ORA-00955
hi there,
I realize that using the "Body editor" to edit a PL/SQL package is useless. Other IDE's prepend the package with "create or replace PACKAGE BODY " while DataGrip does only prepend
create PACKAGE BODY
causing [2017-01-19 14:42:05] [42000][955] ORA-00955: name is already used by an existing object
Is there any chance this can be corrected, or a setting that fixes this behaviour? thanks
Please sign in to leave a comment.
Hi,
Thank you for reporting. Currently, we are working on correct script generation.
Using Datagrip 2017.1.2, I navigate to a package, bring up the context menu (on a package) and select package editor.
I make one tiny change and select the green run button at the top.
And it gives me ORA-00955 name is already used by an existing object.
So, it is not possible to use Datagrip to edit a package ? Or am I missing something obvious....
@Peter Hartman Hi,
Yes, you're right. At current moment you need to "prepend"
We've got some usability issues, e.g. https://youtrack.jetbrains.com/issue/DBE-4015
Thank you.
P.S.: Currently we're working on the issue DBE-4015. Stay tuned
Приветствую @vasily_chernov,
вам удалось пофиксить эту ошибку. раньше удавалось сомпилировать пакеты в DB Oracle. сейчас же нет. у меня тоже выдет ошибку
[2018-01-25 10:49:22] Run CORE.PKG#LIMIT.PKG#LIMIT [HOMEBANK]
[2018-01-25 10:49:22] Connecting to HOMEBANK... (CORE)
[2018-01-25 10:49:22] Using batch mode (1000 insert/update/delete statements max)
-- auto-generated definition
CREATE package body PKG#LIMIT is
-- Проверить лимит пользователя
function check_limit(p_user number, p_new_summa number, p_transfer_type varchar2) return number is
vResult number;
vSum ...
[2018-01-25 10:49:22] [42000][955] ORA-00955: имя уже задействовано для существующего объекта
[2018-01-25 10:49:22] Summary: 1 of 1 statements executed, 1 failed in 761ms (5420 symbols in file)