Toad for Oracle - Beta Forum - Toad for Oracle Beta Program - Toad World

Toad for Oracle Beta Program Community

Toad for Oracle - Beta Forum

Dennis Paulus

Beta Released (12.11.0.75)

Expand content
Beta Notes 12.11.0.75 Internal Bug Fixes

 

Beta Notes

12.11.0.75

Internal Bug Fixes

23 0 / Create an account to join the discussion.
Peter Lang
Follow / 27 Apr 2017 at 1:47pm / Toad for Oracle Beta Program
Latest post by on 27 Apr 2017 at 9:53pm

Code-analysis: Wrong Rule 2131 - Use CONSTANT keyword wherever possible...

Expand content
v_toad_test_type cannot be a constant: CREATE TYPE toad_test_type AS OBJECT ( x NUMBER(1), MEMBER PROCEDURE init_x ); CREATE TYPE BODY toad_test_type AS MEMBER PROCEDURE init_x AS BEGIN x := 1; END init_x;...

v_toad_test_type cannot be a constant:


CREATE TYPE toad_test_type AS OBJECT ( x NUMBER(1), MEMBER PROCEDURE init_x );

CREATE TYPE BODY toad_test_type AS
  MEMBER PROCEDURE init_x AS
  BEGIN
    x := 1;
  END init_x;
END;

CREATE OR REPLACE PROCEDURE toad_test AS
  v_toad_test_type   CONSTANT toad_test_type := NEW toad_test_type(0);  -- Rule 2131
BEGIN
  v_toad_test_type.init_x();
END toad_test;

44 1 / Create an account to join the discussion.
Peter Lang
Follow / 26 Apr 2017 at 2:43pm / Toad for Oracle Beta Program
Latest post by on 27 Apr 2017 at 8:10am

New icons

Expand content
Looks like the icons have been changed recently and I think I'm going to like them. The icon for triggers seems to be wrong (looks like a table instead): And I'm really curious what the new...

Looks like the icons have been changed recently and I think I'm going to like them.

The icon for triggers seems to be wrong (looks like a table instead):

And I'm really curious what the new icons for package spec and body mean. Why is the spec a full box, while the body is empty?

89 12 / Create an account to join the discussion.
kpodaril
Follow / 25 Apr 2017 at 8:45am / Toad for Oracle Beta Program
Latest post by on 26 Apr 2017 at 2:16pm

PLDoc support

Expand content
Hello, I want to use new function PLDoc support released in 12.11.0.31 under menu Database/Report but I don't see it in menu. How to use it? Can I run it also from Automation Designer? ...
Hello,

I want to use new function PLDoc support released in 12.11.0.31 under menu Database/Report but I don't see it in menu. How to use it? Can I run it also from Automation Designer?

Thanks
Unanswered 44 4 / Create an account to join the discussion.
Dennis Paulus

Beta Released (12.11.0.70)

Expand content
Beta Notes 12.11.0.70 Internal Bug Fixes

 

Beta Notes

12.11.0.70

Internal Bug Fixes

33 0 / Create an account to join the discussion.
Damir Vadas
Follow / 21 Apr 2017 at 10:23am / Toad for Oracle Beta Program
Latest post by on 24 Apr 2017 at 4:36pm

Wrong parsing binds ([Error] Explain Plan (12: 23): ORA-01745: invalid...

Expand content
Toad 12.11.0.68 x64, Oracle 11.2.0.3 x64, Client Oracle 11.2.0.3 x64, Windows 7 x64. Seems that parsing on bind is not working as expected. SELECT ash.inst_id iid, username, '@sql_id '||ash...

Toad 12.11.0.68 x64, Oracle 11.2.0.3 x64, Client Oracle 11.2.0.3 x64, Windows 7 x64.

Seems that parsing on bind is not working as expected.

SELECT ash.inst_id iid,
       username,
       '@sql_id '||ash.inst_id || ' ' ||ash.sql_id a_sql_id,
       sql.child_number,
       sql.plan_hash_value,
       sql.hash_value,
       TO_CHAR (min(sample_time), 'dd.mm hh24:mi:ss') first_execute,
       TO_CHAR (max(sample_time), 'dd.mm hh24:mi:ss') last_execute,
       min(SUBSTR (sql.sql_text, 1, 55)) sql_text
  FROM gV$active_session_history ash, dba_users u, gv$sql sql
 WHERE     1 = 1
   AND ash.INST_ID = &&1               here is an error
   AND sql.INST_ID = ash.inst_id
   AND sql.sql_id = ash.sql_id
   AND u.USER_ID = ash.USER_ID
   AND u.username like upper('%&&2%')
   AND ash.sql_id IS NOT NULL
GROUP BY     ash.inst_id,   username,  '@sql_id '||ash.inst_id || ' ' ||ash.sql_id,   child_number,  sql.plan_hash_value, sql.hash_value
ORDER BY min(sample_time);


33 2 / Create an account to join the discussion.
paul.jorstad
Follow / 18 Apr 2017 at 8:45am / Toad for Oracle Beta Program
Latest post by on 24 Apr 2017 at 4:31pm

Drag file into editor doesn't work

Expand content
In earlier versions of Toad for Oracle I could drag a file from explorer into the editor. Now I can't, I get a "not allowed" mouse icon. This is a very nice function, and I would really get...

In earlier versions of Toad for Oracle I could drag a file from explorer into the editor. Now I can't, I get a "not allowed" mouse icon. This is a very nice function, and I would really get it back :-)

Windows 8, 64 bit

Toad for Oracle 12.11.0.66, 32 bit

66 2 / Create an account to join the discussion.
kornelis.abe
Follow / 11 Apr 2017 at 7:33am / Toad for Oracle Beta Program
Latest post by on 24 Apr 2017 at 7:41am

Toad failing to execute script

Expand content
All, I'm currently on Toad 12.11.0.64. I was running a script (using F5) and it failed. I then selected cancel, fixed the issue. Pressed F5 again. The script did not execute - just waiting. Maybe...

All,

I'm currently on Toad 12.11.0.64.

I was running a script (using F5) and it failed. I then selected cancel, fixed the issue. Pressed F5 again.
The script did not execute - just waiting. Maybe something locked, so I press Esc.

Now Toad first goes into a non-responding mode (1 or 2 seconds only)
then turns up an internal error, I clicked it away too fast to see what exactly it was.
Something with a lot of FF characters, so probably an Access Violation.

After that, Toad became entirely unresponsive, failing to terminate.
Here's the error log, I hope you can find the issues I mentioned above.

Toad_el_20170411.txt

Kind regards, & wishing you success!
Abe
===

98 4 / Create an account to join the discussion.
Dennis Paulus

Beta Released (12.11.0.68)

Expand content
Beta Notes Create/Alter DB Objects Added a "Use full TNS info from TNSNames.ora" checkbox to the Create/Alter DB Link dialog.�

 

Beta Notes

Create/Alter DB Objects

Added a "Use full TNS info from TNSNames.ora" checkbox to the Create/Alter DB Link dialog.�

53 0 / Create an account to join the discussion.
droeschley_109
Follow / 10 Apr 2017 at 11:02pm / Toad for Oracle Beta Program
Latest post by on 18 Apr 2017 at 5:05pm

Editor - substitution variable followed by period (.) not working...

Expand content
SELECT '&&sub.suffix' FROM dual; Data grid displays &&sub.suffix F5 is working correctly : Time Start: 4/10/2017 5:01:22 PM old: SELECT '&&sub.suffix' FROM...

SELECT '&&sub.suffix' FROM dual;

Data grid displays &&sub.suffix

F5 is working correctly :

Time Start: 4/10/2017 5:01:22 PM
old: SELECT '&&sub.suffix' FROM dual
new: SELECT 'testsuffix' FROM dual

'TESTSUFFIX'
------------
testsuffix
1 row selected.
Elapsed: 00:00:01.03
Time End: 4/10/2017 5:01:25 PM
Elapsed Time for Script Execution: 2 secs

89 8 / Create an account to join the discussion.
Dennis Paulus

Beta Released (12.11.0.66)

Expand content
Beta Notes Compare Multiple Tables Compare Multiple Tables now allows you to select an existing database link to use during compare and sync.

 

Beta Notes

Compare Multiple Tables

Compare Multiple Tables now allows you to select an existing database link to use during compare and sync.

48 0 / Create an account to join the discussion.
Dennis Paulus

Beta Released (12.11.0.65)

Expand content
Beta Notes 12.11.0.65 Internal Bug Fixes

 

Beta Notes

12.11.0.65

Internal Bug Fixes

56 0 / Create an account to join the discussion.
kornelis.abe
Follow / 11 Apr 2017 at 12:22pm / Toad for Oracle Beta Program

Report changes when refreshing folder links in the project window

Expand content
All, as I was refreshing folder links in various folders in my projects window, I had no clue what changes were being made. Would it be possible to have a pop-up listing the additions and deletions being...

All,

as I was refreshing folder links in various folders in my projects window,
I had no clue what changes were being made.
Would it be possible to have a pop-up listing the additions and deletions being made?

Just an idea...

Abe Kornelis
==========

27 0 / Create an account to join the discussion.
Dennis Paulus
Follow / 10 Apr 2017 at 5:35pm / Toad for Oracle Beta Program
Latest post by on 10 Apr 2017 at 7:23pm

Beta Released (12.11.0.64)

Expand content
Beta Notes Editor - Execute Script (F5) An Errors tab has been added to the Script Output window of the editor. This will provide quick access to error information when executing code as a script. TNSNames...

 

Beta Notes

Editor - Execute Script (F5)

An Errors tab has been added to the Script Output window of the editor. This will provide quick access to error information when executing code as a script.

TNSNames Editor

The TNS Names editor has been redesigned for better overall usability.� The new editor functions similarly to Toad's internal editor with a main tabbed editor and a navigation panel on the left hand side.� You can still create, edit, clone, and delete entries visually, however this should provide a much cleaner way of working with TNS files directly.

Additional features supported:
1. Ability to open multiple files, instead of only two
2. Allows comparing TNS tab contents in Toad's Compare Files window
3. Supports multiple TNS entry formats
4. The LHS navigation panel will show when multiple items exist for a node. When viewing in host mode, this can be useful in detecting duplicate TNS entries with different names

Automation Designer Code Tester

Test definitions are now grouped by database object when adding new items to Code Tester action.

48 1 / Create an account to join the discussion.
wickliffe.larry

Run as script fails, <F5>, but run statement and show all records...

Expand content
Good Morning TOAD Team, This is too weird. I'm running the latest beta, 12.11.0.63. Run as script fails, <F5>, but run statement and show all records, <F9>, succeeds. Full script...
Good Morning TOAD Team,

       This is too weird.  I'm running the latest beta, 12.11.0.63.  Run as script fails, <F5>, but run statement and show all records, <F9>, succeeds.   Full script attached as it is long.

       My usual timing script:

select to_char(SYSTIMESTAMP,'HH24:MI:SSxFF') as "Start" from dual;

/* Statement to tune */
Select ...

select to_char(SYSTIMESTAMP,'HH24:MI:SSxFF') as "End" from dual;



       Run as script , <F5>, fails with the following error on the test script, but there is no error running the SQL under test <F9>:

Start            
------------------
08:50:13.055367  
1 row selected.
Error at line 16
An invalid character was found in text content.


End              
------------------
08:52:39.428086  
1 row selected.





39 0 / Create an account to join the discussion.
wickliffe.larry

<F5> current statement count off by 1

Expand content
Good Morning TOAD Team, I'm running the latest beta, 12.11.0.67. On script execution, <F5>, the reported statement being executed is off by one. I'm running a three statement...
Good Morning TOAD Team,

       I'm running the latest beta, 12.11.0.67.  On script execution, <F5>, the reported statement being executed is off by one.

I'm running a three statement script; the first and last are selecting a timestamp and execute very quickly; the middle statement is simply being timed.



select to_char(SYSTIMESTAMP,'HH24:MI:SSxFF') as "Start" from dual;

/* some statement another team ask to be tuned */
Select ...

select to_char(SYSTIMESTAMP,'HH24:MI:SSxFF') as "End" from dual;



       When running I should only see  Processing script Task 2 of 3, but what I see is Task 3 of 3 (see attached) and a record count at some point.  The first and last SQL return one record.

       Please correct the Task counter.
25 0 / Create an account to join the discussion.
steven.kladitis_687
Follow / 6 Apr 2017 at 5:32pm / Toad for Oracle Beta Program
Latest post by on 6 Apr 2017 at 6:05pm

SHOW RECYCLEBIN

Expand content
--> SHOW RECYCLEBIN does not work in latest BETA.

--> SHOW RECYCLEBIN

does not work in latest BETA.

73 1 / Create an account to join the discussion.
Dennis Paulus

Beta Released (12.11.0.63)

Expand content
Beta Notes Code Tester New test cases can be created and added to existing test definitions.

 

Beta Notes

Code Tester

New test cases can be created and added to existing test definitions.

58 0 / Create an account to join the discussion.
kornelis.abe
Follow / 17 Feb 2017 at 7:37am / Toad for Oracle Beta Program
Latest post by on 6 Apr 2017 at 12:53pm

Inconsistent formatting of comment blocks

Expand content
All, I'm currently on Toad 12.11.0.42. While formatting a long script, I noticed some inconsistencies in the formatted code. Please see attachment for details. Issue #1: in between two successive...

All,

I'm currently on Toad 12.11.0.42.

While formatting a long script, I noticed some inconsistencies in the formatted code.
Please see attachment for details.

Issue #1: in between two successive comment blocks, a blank separator line is inserted
               on line 5, but not on lines 126, 300, etc. Only the first double block gets an additional blank line.

Issue #2: between a block of code and the next comment block a blank line is normally inserted
                but not on all occasions. E.g. line 6057/6058 are not separated, whereas 6031/6033 have
                been separated by a single intervening blank line.

Issue #3: An invocation of another script followed by a double-dash comment has the two dashes
                separated by a single intervening space. See e.g. line 32.

Could you please fix these issues?

Thanks in advance,
Abe Kornelis
==========

20170217 $install_tables.sql

107 3 / Create an account to join the discussion.
kornelis.abe
Follow / 10 Feb 2017 at 3:02pm / Toad for Oracle Beta Program
Latest post by on 6 Apr 2017 at 12:15pm

impractical alignment of parameter values in list of named parame...

Expand content
All, I'm on Toad 12.11.0.39. The formatter seems to be trying to align the => signs in my list of named parameters. But it is breaking lines when it should not. E.g. it breaks p_debug =>...

All,

I'm on Toad 12.11.0.39.

The formatter seems to be trying to align the => signs in my list of named parameters.
But it is breaking lines when it should not.
E.g. it breaks p_debug => 'Nodebug'  into two separate code lines :-(

This is the sample query:

select   category_old as category_economical
       , category_new as category_physical
       , count(*) as aantal
from     (select r.partno
               , r.compno
               , substr(r.category_with_repl_reason, 1, 1)
                   as category_new
               , substr(stock_stats.summarize.determine_category( /* turnover = sales (of parts+kits) - returns, include turnover of replaced parts */
                          p_partno =>
                            r.partno
                        , p_synonym_of =>
                            r.synonym_of
                        , p_value_lines =>
                            coalesce(r.value_lines, 0) + coalesce(r.repl_value_lines, 0)
                        , p_qty_on_stock =>
                            coalesce(r.qty_on_stock_economical, 0) + coalesce(r.repl_qty_on_stock_economical, 0)
                        , p_turnover_12m =>
                              coalesce(r.qty_sold_1yr, 0)
                            + coalesce(r.qty_uninvoiced, 0)
                            - coalesce(r.qty_returned_1yr, 0)
                            - coalesce(r.qty_uninvoiced_returns, 0)
                            + coalesce(r.repl_qty_sold_1yr, 0)
                            + coalesce(r.repl_qty_uninvoiced, 0)
                            - coalesce(r.repl_qty_returned_1yr, 0)
                            - coalesce(r.repl_qty_uninvoiced_returns, 0)
                        , p_turnover_24m =>
                              coalesce(r.qty_sold_2yr, 0)
                            + coalesce(r.qty_uninvoiced, 0)
                            - coalesce(r.qty_returned_2yr, 0)
                            - coalesce(r.qty_uninvoiced_returns, 0)
                            + coalesce(r.repl_qty_sold_2yr, 0)
                            + coalesce(r.repl_qty_uninvoiced, 0)
                            - coalesce(r.repl_qty_returned_2yr, 0)
                            - coalesce(r.repl_qty_uninvoiced_returns, 0)
                        , p_qty_reserved =>
                            coalesce(r.qty_reserved, 0) + coalesce(r.repl_qty_reserved, 0)
                        , p_create_mon =>
                            case
                              when r.linetype = 'G'
                              then
                                coalesce(r.created_global, 200301)
                              else
                                coalesce(r.created_psbase
                                       , r.created_local
                                       , r.created_global
                                       , 200301
                                        )
                            end
                        , p_current_period =>
                            r.mon_code
                        , p_debug =>
                            'Nodebug'
                        )
                      , 1
                      , 1
                       )
                   as category_old
          from   results r
          where      r.mon_code = 201612
                 and r.linetype = 'D'
                 and r.redundancy_code = 'N'
                 and r.compno > 0)
group by category_old, category_new
order by category_old, category_new;

As you can see, some parameter values are calculated using a lengthy expression.
Those are formatted okay, but the short ones that should fit on a single code line
are broken into two lines as well.

I would like the => symbols to be aligned, but rather not this way!

Kind regards,
Abe Kornelis.
==========

141 5 / Create an account to join the discussion.