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

Toad for Oracle Beta Program Community

Toad for Oracle - Beta Forum

Rod
Follow / 13 Jan 2017 at 9:05pm / Toad for Oracle Beta Program
Latest post by on 13 Jan 2017 at 9:11pm

Getting a Slow performance in Toad for Oracle 12.10 when I am trying...

Expand content
Getting a slow response in Toad for Oracle 12.5.1, 12.10 and now with Beta Version 12.11.- When I am trying to open Schema Browser | Script Tab| It takes a lot of time to show the DDL. in some cases almost...

Getting a slow response in Toad for Oracle 12.5.1, 12.10 and now with Beta Version 12.11.- When I am trying to open Schema Browser | Script Tab|  It takes a lot of time to show the DDL. in some cases almost 2 minutes.
I'm using 64 bit environment (Windows, Database Server 12c, Toad for Oracle and Oracle Client 12.1)

66 1 / Create an account to join the discussion.
paul.jorstad

Not able to drag file into editor

Expand content
I'm not able to drag'n'drop files into the Editor anymore. This has worked on a previous beta version. When trying to drag a file into the editor, I see a "not allowed" sign as the...

I'm not able to drag'n'drop files into the Editor anymore. This has worked on a previous beta version. When trying to drag a file into the editor, I see a "not allowed" sign as the mouse cursor.

----------------------------------------------------------------------------------------------------------

Toad for Oracle Beta 12.11.0.25 om Windows 8, 32-bit (Toad and Oracle client)

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

Beta Released (12.11.0.25)

Expand content
Internal Bug Fixes

Internal Bug Fixes

45 0 / Create an account to join the discussion.
msacks
Follow / 12 Aug 2014 at 3:40pm / Toad for Oracle Beta Program
Latest post by on 12 Jan 2017 at 12:53pm

ERROR: API Guard (QP5 version 5.269.14213.34746)

Expand content
Hi, Installed the latest Toad Beta this morning and getting a lot of error messages. The most recent was this (see attached): API Guard (QP5 version 5.269.14213.34746) Function...
Hi,

Installed the latest Toad Beta this morning and getting a lot of error messages.  

The most recent was this (see attached):

API Guard (QP5 version 5.269.14213.34746)

Function 5026 (QP5_CLS_START_CANCELING)

The only thing I was doing was running a Stored Procedure.
12999 19 / Create an account to join the discussion.
Peter Lang
Follow / 11 Jan 2017 at 8:28am / Toad for Oracle Beta Program
Latest post by on 12 Jan 2017 at 6:54am

Code Analysis: Rule 3807 vs 5601 (Avoid using RETURN statements in...

Expand content
Both rules seem to be the same. I guess that one of them is new and should replace the other one?

Both rules seem to be the same. I guess that one of them is new and should replace the other one?

Unanswered 72 3 / Create an account to join the discussion.
Peter Lang
Follow / 10 Jan 2017 at 11:06am / Toad for Oracle Beta Program
Latest post by on 11 Jan 2017 at 7:46pm

Code analysis: Wrong 5406 (unused parameters) with aggregate func...

Expand content
The input parameter is marked with "Remove unused parameters or modify code to use the parameter." in the STRAGG function (by Tom Kyte). Aggregat functions cannot "use" their parameters...

The input parameter is marked with "Remove unused parameters or modify code to use the parameter." in the STRAGG function (by Tom Kyte). Aggregat functions cannot "use" their parameters.

create or replace function stragg
  ( input varchar2 )
  return varchar2
  deterministic
  parallel_enable
  aggregate using stragg_type
;

Unanswered 45 1 / Create an account to join the discussion.
Peter Lang
Follow / 16 Nov 2016 at 10:37am / Toad for Oracle Beta Program
Latest post by on 11 Jan 2017 at 6:11pm

Code Assist: Not working for columns when another column comes af...

Expand content
Code completion does not work in the following case. It does work before I type the "a" (tab.| works). SELECT tab.owner, tab.a| tab.table_name FROM all_tables tab;

Code completion does not work in the following case. It does work before I type the "a" (tab.| works).

SELECT tab.owner,
       tab.a|
       tab.table_name
  FROM all_tables tab;

Unanswered 141 2 / Create an account to join the discussion.
Peter Lang
Follow / 10 Jan 2017 at 8:27am / Toad for Oracle Beta Program
Latest post by on 11 Jan 2017 at 6:06pm

Allow to refresh Pick-list dropdown by shortcut

Expand content
Is there already a shortcut to refresh the pick-list dropdown? It happens all the time that I create new or change existing packages, and then I need to use the mouse to press the refresh button in the...

Is there already a shortcut to refresh the pick-list dropdown?

It happens all the time that I create new or change existing packages, and then I need to use the mouse to press the refresh button in the pick-list dropdown.

If this option does not exist right now, would it be possible to trigger a reload by using the current shortcut to open the dropdown while the dropdown is displayed?
I would trigger the dropdown with my shortcut, realize that the element I'm searching for is not in the list and just press the shortcut again, now getting the refreshed list.

Unanswered 65 1 / Create an account to join the discussion.
Peter Lang
Follow / 10 Jan 2017 at 8:07am / Toad for Oracle Beta Program
Latest post by on 11 Jan 2017 at 5:04pm

Code Templates: Cancel in variable substitution not working as ex...

Expand content
Variable substitution can be used in Code Templates (using &&) which displays the variable substitution dialog before pasting the template. This dialog allows to [Cancel] but this only affects...

Variable substitution can be used in Code Templates (using &&) which displays the variable substitution dialog before pasting the template.

This dialog allows to [Cancel] but this only affects the substitution. The template is still pasted afterwards.

37 2 / Create an account to join the discussion.
phyllis.helton_1150
Follow / 10 Jan 2017 at 7:10pm / Toad for Oracle Beta Program
Latest post by on 10 Jan 2017 at 7:17pm

Copy Column Names -

Expand content
John, Thank you so much for adding the "Copy Column Names" functionality to the grids!  I LOVE this new feature and see myself using it all the time. For those who have no clue what I'm talking...
John,

Thank you so much for adding the "Copy Column Names" functionality to the grids!  I LOVE this new feature and see myself using it all the time.

For those who have no clue what I'm talking about, I submitted a IdeaPond suggestion to allow for copying the visible column names from a grid to the clipboard for use in a select statement.  John added this to the column selector right-click menu of the grid.  

Blessings,

Phyllis

--
Phyllis Helton
Data Magician
Security Gestapo
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office  407-515-4452
69 1 / Create an account to join the discussion.
droeschley_109
Follow / 10 Jan 2017 at 3:44pm / Toad for Oracle Beta Program
Latest post by on 10 Jan 2017 at 5:16pm

SB Data Appearance Toggles- when turned on, stay on for other tab...

Expand content
When I toggle the Group Panel or Navigator to appear for a particular table, then select another table(s) that I haven't toggled on (or off), the Data grid Appearance is set to that of the previous...

When I toggle the Group Panel or Navigator to appear for a particular table, then select another table(s) that I haven't toggled on (or off), the Data grid Appearance is set to that of the previous table.  If I toggle off the Group Panel or Navigator for the 2nd table, clicking between the 2 tables acts as expected.  

Can all the tables that haven't been explicitly toggled ON be set to OFF?

87 3 / Create an account to join the discussion.
Mark G
Follow / 4 Jan 2017 at 9:03am / Toad for Oracle Beta Program
Latest post by on 10 Jan 2017 at 3:05pm

Access Violation when exporting to Excel

Expand content
Using 12.11.0.20, if I right-click the data grid in the editor and select Export Dataset and then choose Excel File as the export format and hit ok, the dataset is exported and excel opens showing all...

Using 12.11.0.20, if I right-click the data grid in the editor and select Export Dataset and then choose Excel File as the export format and hit ok, the dataset is exported and excel opens showing all the data. When I then close Excel, I get a Toad access violation at address 00000000041A089F in module 'Toad.exe'. Read of address FFFFFFFFFFFFFFFF.

In fact, since I started this post, I noticed there was a new beta (12.11.0.21) so I have downloaded it and tried again. This time when I close Excel it just says "Abstract Error". It seems to happen occasionally with other types (i.e. Insert Statements) but it is consistent when using Excel File.

I can post the Eureka log if necessary but I'm hoping you'll be able to reproduce it.

Thanks,

Mark.

Answered 191 14 / Create an account to join the discussion.
kornelis.abe
Follow / 10 Jan 2017 at 1:45pm / Toad for Oracle Beta Program
Latest post by on 10 Jan 2017 at 1:50pm

F9 fails trying to use a CTE-name as an independent table

Expand content
All, I'm still on Toad 12.11.0.22 while working on a script (anonymous block) I block the query used to define a cursor, then hit F9, expecting to have the result grid populated. Usually, this...

All,

I'm still on Toad 12.11.0.22

while working on a script (anonymous block) I block the query used
to define a cursor, then hit F9, expecting to have the result grid populated.

Usually, this works, but sometimes I get an ORA-00942: table or view does not exist

Spooling the SQL shows that the failing statement is:
select *
from   current_rows

Oracle is correct in flagging this as an error: current_rows is not the name
of any table; it is the name of a CTE defined in the cursor.

This is the cursor definition:
  cursor load_messages
  is
    with current_rows
         as (select   pl.pono
                    , pl.porowpos
                    , pl.porowseq
                    , max(pl.rowstatus_new) keep (dense_rank last order by pl.timestamp) as rowstatus
                    , max(pl.timestamp) as timestamp
             from     iib_krg.porow_log pl
             where    pl.status not in ('0', '1') -- exclude unprocessed events
             and pono = 2116943
             group by pl.pono, pl.porowpos, pl.porowseq
             having       max(pl.change_type) keep (dense_rank last order by pl.timestamp) in ('I', 'U') -- skip deleted rows
                      and max(pl.otype_new) keep (dense_rank last order by pl.timestamp) = '31'
                      and max(pl.rowstatus_new) keep (dense_rank last order by pl.timestamp) in (300, 310, 320, 322)
                      and max(pl.podeltype_new) keep (dense_rank last order by pl.timestamp) in ('L', 'AT'))
       , po_full
         as (select   cr.pono
                    , -1 as porowpos
                    , -1 as porowseq
                    , max(cr.timestamp) as timestamp
             from     current_rows cr
             group by cr.pono)
       , asn_c
         as (select cr.pono
                  , cr.porowpos
                  , cr.porowseq
                  , cr.timestamp
             from   current_rows cr
             where  cr.rowstatus = 322)
    select pono
         , porowpos
         , porowseq
         , timestamp
    from   po_full
    union all
    select pono
         , porowpos
         , porowseq
         , timestamp
    from   asn_c
    order by pono
           , porowpos
           , porowseq
           , timestamp;

Can you please fix this issue?

Thanks in advance & Kind regards,
Abe Kornelis
==========

44 1 / Create an account to join the discussion.
kornelis.abe

F5-popup fails to detect end of script

Expand content
All, I'm currently on Toad 12.11.0.22. I had a script running overnight in my virtual desktop which I disconnected after starting the script with F5. This morning, I find the Toad session main...

All,

I'm currently on Toad 12.11.0.22.

I had a script running overnight in my virtual desktop which I disconnected after starting the script with F5.

This morning, I find the Toad session main window stating that the script completed after 09:09:50,
yet the "Processing Script" pop-up is still counting, suggesting the script has not yet completed.

Here's a screen-shot:

Now of course, it would be easy to het Escape and be done.

I'll let the session be for today - just in case you want me
to produce additional diagnostics from the session.

The main issue - from my point of view - is that the pop-up
suggests the script is still running. Ittook me about ten minutes
before I noticed that the main display was telling a
different story!

Kind regards,
Abe
===

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

Beta Released (12.11.0.23)

Expand content
Internal Bug Fixes

Internal Bug Fixes

38 0 / Create an account to join the discussion.
rtx
Follow / 8 Nov 2016 at 1:18pm / Toad for Oracle Beta Program
Latest post by on 5 Jan 2017 at 10:15pm

Double insert

Expand content
Hi! 12.11.06/12.10.0.30 DROP TABLE tst#; CREATE TABLE tst# ( ID NUMBER ); CREATE SEQUENCE tst#_seq; CREATE OR REPLACE PROCEDURE proc_tst# (cur OUT SYS_REFCURSOR) IS BEGIN INSERT INTO tst# (id...

Hi!

12.11.06/12.10.0.30

DROP TABLE tst#;

CREATE TABLE tst#
(
    ID   NUMBER
);

CREATE SEQUENCE tst#_seq;

CREATE OR REPLACE PROCEDURE proc_tst# (cur OUT SYS_REFCURSOR)
IS
BEGIN
    INSERT INTO tst# (id)
         VALUES (tst#_seq.NEXTVAL);

    OPEN cur FOR SELECT tst#_seq.CURRVAL FROM DUAL;
END;

DELETE FROM tst# WHERE 1=1;

BEGIN
    proc_tst#(:cur);   
END;

SELECT * FROM tst#;

It's all right with

DECLARE
 cur sys_refcursor;
BEGIN
 proc_tst#(cur);
END; 

177 4 / Create an account to join the discussion.
kornelis.abe
Follow / 4 Jan 2017 at 2:31pm / Toad for Oracle Beta Program
Latest post by on 5 Jan 2017 at 7:29am

Cannot set focus to explain window

Expand content
All, Happy new year! I'm currently on Toad 12.11.0.21 From the editor window I ran a query, results show in the data grid on the bottom half of the screen. This is ok. Then I brought up a package's...

All,

Happy new year!

I'm currently on Toad 12.11.0.21

From the editor window I ran a query, results show in the data grid on the bottom half of the screen. This is ok.
Then I brought up a package's content by pressing <F4> which works ok as well.
Then, from the data grid, I bring up the single record viewer, which also works ok.

But now, after clicking the explain window, when I use the scroll wheel on the mouse,
it's the single record viewer pane that scrolls, rather than the explain window.

As a consequence, while checking code against actual data,
I have to close and reopen the single record viewer every time I want to scroll
to another section of my package :-(

Would it be possible to switch between the windows and scroll the current window?

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

68 2 / Create an account to join the discussion.
Dennis Paulus

Beta Released (12.11.0.22)

Expand content
Internal Bug Fixes

Internal Bug Fixes

48 0 / Create an account to join the discussion.
Brad Boddicker
Follow / 23 Dec 2016 at 6:54pm / Toad for Oracle Beta Program
Latest post by on 4 Jan 2017 at 3:37pm

Beta Released (12.11.0.20)

Expand content
Beta Notes Named Queries in SB-Tables-Data You can now name and save queries in SB-Tables-Data, in the same way filters can be saved. Details here: http://www.toadworld.com/products/toad-for-oracle...
Beta Notes
Named Queries in SB-Tables-Data

You can now name and save queries in SB-Tables-Data, in the same way filters can be saved.

Details here:  http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2016/12/23/named-queries-in-sb-tables-data

143 6 / Create an account to join the discussion.
Dennis Paulus

Beta Released (12.11.0.21)

Expand content
Beta Notes Formatter Of the following statements many more instances will be formatted: SELECT ...COST() PREDICTION() PREDICTION_DETAILS() ALTER SYSTEM ALTER TABLE ALTER TABLESPACE...

Beta Notes

Formatter

Of the following statements many more instances will be formatted:

  • SELECT ...COST() PREDICTION() PREDICTION_DETAILS()
  • ALTER SYSTEM
  • ALTER TABLE
  • ALTER TABLESPACE
  • CREATE TABLESPACE
  • CREATE INDEX
  • ADMINISTER KEY MANAGEMENT

Grammar

ALTER/CREATE TABLE: The type PLS_INTEGER cannot be used as a data type, this will now be flagged as an error.

Grammar 12cR1

Grammar update to the latest 12cR1 docs (DDL) :

  • ADMINISTER KEY MANAGEMENT
  • CREATE INDEX
  • CREATE PLUGGABLE DATABASE
  • ALTER/CREATE TABLESPACE
  • ALTER SYSTEM
  • ALTER DISKGROUP

Grammar update to the latest 12cR1 docs (expressions, functions and common clauses) :
      * PREDICTION functions
      * FORMAT JSON clause in expressions

42 0 / Create an account to join the discussion.