Log-In to post
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)
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 126.96.36.199 om Windows 8, 32-bit (Toad and Oracle client)
Internal Bug Fixes
Both rules seem to be the same. I guess that one of them is new and should replace the other one?
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;
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;
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.
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.
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?
Using 188.8.131.52, 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 (184.108.40.206) 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.
I'm still on Toad 220.127.116.11
while working on a script (anonymous block) I block the query usedto 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 nameof 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==========
I'm currently on Toad 18.104.22.168.
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 meto produce additional diagnostics from the session.
The main issue - from my point of view - is that the pop-upsuggests the script is still running. Ittook me about ten minutesbefore I noticed that the main display was telling adifferent story!
DROP TABLE tst#;
CREATE TABLE tst#( ID NUMBER);
CREATE SEQUENCE tst#_seq;
CREATE OR REPLACE PROCEDURE proc_tst# (cur OUT SYS_REFCURSOR)ISBEGIN 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;
Happy new year!
I'm currently on Toad 22.214.171.124
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 scrollto another section of my package :-(
Would it be possible to switch between the windows and scroll the current window?
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
Of the following statements many more instances will be formatted:
ALTER/CREATE TABLE: The type PLS_INTEGER cannot be used as a data type, this will now be flagged as an error.
Grammar update to the latest 12cR1 docs (DDL) :
Grammar update to the latest 12cR1 docs (expressions, functions and common clauses) : * PREDICTION functions * FORMAT JSON clause in expressions