I have found a problem while operating on fields of a stored procedure.
Consider a procedure:
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...
I have found a bug, related to automatic substitution of variables for variables with trailing colons.
Consider a query:
SELECT /*+ FIRST_ROWS(1) */ hoa.id_hist_obiekt_adres
FROM historia_obiektu ho
LEFT OUTER JOIN hist_obiekt_adres hoa
ON hoa.id_historii_obiektu =...
When I declare a cursor:
c is select ...;
then an variable:
zm c%ROWTYPE;
When I am trying to get list of fields, I type 'zm.' and press the button that calls 'Code Assistant'. PL/SQL Developer doesn't react.
Version 6.0.2.880 (MBCS)
I have found a bug in positioning a window with a procedure, when one is drag and dropped into pl/sql developer's desktop from a tree on the left.
how to reproduce:
1. set Tools/ Preferences / User Interface / Browser / Drag & Drop option = Edit.
2. drag a procedure from left tree pane...
problem: Switching from XML to TEXT destroys XML document.
version: 6.0.2.880 (MBCS)
1. open CLOB containing an XML document in editor
2. press the "Format XML" button
3. switch to TEXT tab
notice that XML indenting was preserved, thus in some of my documents (long text inside an XML node)...