You will no longer receive e-mail notifications from this forum.
Log-In to post
Internal Bug Fixes
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 2131BEGIN v_toad_test_type.init_x();END toad_test;
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?
Toad 22.214.171.124 x64, Oracle 126.96.36.199 x64, Client Oracle 188.8.131.52 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 NULLGROUP BY ash.inst_id, username, '@sql_id '||ash.inst_id || ' ' ||ash.sql_id, child_number, sql.plan_hash_value, sql.hash_valueORDER BY min(sample_time);
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 184.108.40.206, 32 bit
I'm currently on Toad 220.127.116.11.
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.
Kind regards, & wishing you success!Abe===
Create/Alter DB Objects
Added a "Use full TNS info from TNSNames.ora" checkbox to the Create/Alter DB Link dialog.�
SELECT '&&sub.suffix' FROM dual;
Data grid displays &&sub.suffix
F5 is working correctly :
Time Start: 4/10/2017 5:01:22 PMold: SELECT '&&sub.suffix' FROM dualnew: SELECT 'testsuffix' FROM dual
'TESTSUFFIX'------------testsuffix 1 row selected.Elapsed: 00:00:01.03Time End: 4/10/2017 5:01:25 PMElapsed Time for Script Execution: 2 secs
Compare Multiple Tables
Compare Multiple Tables now allows you to select an existing database link to use during compare and sync.
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...
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.
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 window3. Supports multiple TNS entry formats4. 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.
--> SHOW RECYCLEBIN
does not work in latest BETA.
New test cases can be created and added to existing test definitions.
I'm currently on Toad 18.104.22.168.
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==========
I'm on Toad 22.214.171.124.
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 aantalfrom (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_neworder 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 lineare broken into two lines as well.
I would like the => symbols to be aligned, but rather not this way!
Kind regards,Abe Kornelis.==========