Michal Kolodziejski
Member
I have found a problem while operating on fields of a stored procedure.
Consider a procedure:
1. Click left-mouse-button over a word 'obiekt', that is a part of an expression 'obiekt.id_obiektu' on the second line. (DO NOT SELECT the word 'obiekt', just place editing cursor on it).
2. From context-menu select 'Edit' option.
Now - an 'edit object' window appears, but even its title isn't 'obiekt' as expected, but 'obiekt.id_obiektu'.
If I try to remove check with a name
CKC_OGOLNOSPAWNA_OBIEKT, the resulting code is as follows:
Its not the same in every situation, for example when I use 'Remove' optien on an column, the resulting SQL-code is formed correctly.
I have encountered similiar behaviour when using following options:
'View', 'Rename', 'Drop', 'Query data', 'Edit Data' and 'Export'.
'Rename' - please check it thoroughly, because in every situation I got different results, but the most common, was that when I have renamed a column, it was REMOVED from a check, not renamed in it. (even when I have selected the word 'obiekt', not only placed cursor on it as pointed above).
'Export' - Here the problem is that PL/SQL Developer don't automatically select (highlight) according table, when table 'obiekt' should be highlighted.
version tag: Version 6.0.2.880 (MBCS)
Consider a procedure:
Code:
CREATE OR REPLACE PROCEDURE KN.ka_ob_obiekt_brs (
k_obiekt OUT types.cursorType,
p_id_obiektu IN obiekt.id_obiektu%TYPE,
p_id_rodzaju_obiektu IN obiekt.id_rodzaju_obiektu%TYPE,
p_identyfikator IN obiekt.numery%TYPE,
...
2. From context-menu select 'Edit' option.
Now - an 'edit object' window appears, but even its title isn't 'obiekt' as expected, but 'obiekt.id_obiektu'.
If I try to remove check with a name
CKC_OGOLNOSPAWNA_OBIEKT, the resulting code is as follows:
Code:
alter table OBIEKT.ID_RODZAJU_OBIEKTU
drop constraint CKC_OGOLNOSPAWNA_OBIEKT;
I have encountered similiar behaviour when using following options:
'View', 'Rename', 'Drop', 'Query data', 'Edit Data' and 'Export'.
'Rename' - please check it thoroughly, because in every situation I got different results, but the most common, was that when I have renamed a column, it was REMOVED from a check, not renamed in it. (even when I have selected the word 'obiekt', not only placed cursor on it as pointed above).
'Export' - Here the problem is that PL/SQL Developer don't automatically select (highlight) according table, when table 'obiekt' should be highlighted.
version tag: Version 6.0.2.880 (MBCS)