Recent content by j.bencze

Thanks Marco, but the error appears even if I don't use an if-then-else construct: Ex. DECLARE i PLS_INTEGER := 0; BEGIN FOR sor IN (SELECT 1 FROM DUAL WHERE 1 = 0) LOOP DBMS_OUTPUT.PUT_LINE('1') ; DBMS_OUTPUT.PUT_LINE('2') ; i := i +1; END LOOP; i := i + 1...

When debugging an implicit cursor loop in a test window some steps are shown erroneously. Ex. DECLARE i PLS_INTEGER := 0; BEGIN FOR sor IN (SELECT 1 FROM DUAL UNION SELECT 2 FROM DUAL) LOOP IF i = 0 THEN DBMS_OUTPUT.PUT_LINE('A') ; ELSE...

Thank You, Marco!

Hi! Is it possible to change directories (Preferences/Files/Directories) automatically after loging on different databases? Or is it possible to use variable names ($OSUSER) in the same directory definitions? Thanks! J.Bencze