Toad for Oracle Forum - Toad for Oracle - Toad World
Danny Torres
Follow / 1 Nov 2016 at 1:48pm / Toad for Oracle
Latest post by on 26 Jun 2017 at 2:33pm

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

925 2 / Create an account to join the discussion.
Danny Torres
Follow / 14 Sep 2016 at 5:03pm / Toad for Oracle
Latest post by on 26 Jun 2017 at 9:58am

How to get the most out of this forum – Best practices for what information...

Expand content
The better a problem is described, the better the assistance tends to be. In order to better assist with your issue at hand, please include the following information in your initial post. - Product,...

The better a problem is described, the better the assistance tends to be.
In order to better assist with your issue at hand, please include the following information in your initial post.

-          Product, Version, and relevant environment details.

-          Include a screenshot of the problem

-          Describe the problem fully. What result was expected?

-          Can the issue be created on demand or is it intermittent?

-          If the problem can be generated faithfully, what are the exact steps to recreate the problem?

-          Any other pertinent information (see below)


How to create Support Bundles

The support bundle window provides information about several aspects of your Oracle and Toad setups. In addition, the Support Bundle lets you easily report problems to our peer-to-peer mailing lists or directly to Support.
If Toad itself fails, the Error dialog box displays. This type of an error creates a log, saved as toad.elf. This Eureka LogFile (.elf) contains both the application information and the callstack of the error created, and can be very helpful to Support in solving issues you are having with Toad.

To create a support bundle:

Select Help | Support Bundle.

Review the following for additional information:

Email Dell Support

This opens the "Email Dell Support" window with instructions and links to contact Support, and to open a new case or service request.

Dell Web Support

This opens Dell Software's award-winning Support portal in your default browser, with access to Licensing Assistance, the searchable Knowledge Base, product downloads and more.

Attach TOAD.INI (or SQL Tuning Support details) to emails

If selected, this attaches the details to any email sent through the support bundle, whether it is to the peer-to-peer Toad list or to Support.

 *Note: Please refrain from including private data in your posts. Be as thorough as you can with the provided info. We will reply to you as quick as possible. We are glad to assist you. 

Latest Release Information: 

This announcement includes information on our latest releases, links to our downloads and documentation and overview of new features.  This way you can stay as informed as possible: 

-          "What’s New" Section:

-          http://documents.software.dell.com/toad-for-oracle/12.9/release-notes/new-features

-           

-          Link to Download & Documentation:

-          https://support.software.dell.com/toad-for-oracle/12.9

-           

-          Link to Trial:

-          https://software.dell.com/products/toad-for-oracle/software-downloads.aspx

-           

-          Overview of new feature(s) (with link to the release notes)

-          http://documents.software.dell.com/toad-for-oracle/12.9/release-notes/new-features

-          http://documents.software.dell.com/toad-for-oracle/12.9/release-notes/  

 

Top 5 Knowledge Base Articles:

On this post, you can find our top trending knowledge articles that other customers are inquiring about and popular solutions.

This month’s Top Knowledge Base Articles

  1. Video - How to make a database connection using Direct, TNS and LDAP in Toad for Oracle (205157) https://support.software.dell.com/toad-for-oracle/kb/205157
  2. VIDEO - How to install Toad for Oracle using the new Web Installer (178737) https://support.software.dell.com/toad-for-oracle/kb/178737
  3. Video - How to use the SQL Tracker tool? (193849) https://support.software.dell.com/toad-for-oracle/kb/193849
  4. VIDEO - Get more out of your Toad for Oracle investment with free training. (145507) https://support.software.dell.com/toad-for-oracle/kb/145507
  5. Video: Need help to download Toad for Oracle from the Support Portal. (108974) https://support.software.dell.com/toad-for-oracle/kb/108974

 Feel free to browse them. Remember to sign in to your account to view.

1419 1 / Create an account to join the discussion.
devnull
Follow / 22 Jun 2017 at 12:49pm / Toad for Oracle
Latest post by on 28 Jun 2017 at 2:57am

Bug - Bind variables not recognised in model clause - Toad 12.10.0...

Expand content
It appears there is a bug in the model clause where bind variables are not picked up for value entry at execution time. See the following simple example - if run in Toad, the window pops up to accept the...

It appears there is a bug in the model clause where bind variables are not picked up for value entry at execution time. See the following simple example - if run in Toad, the window pops up to accept the bind variable value input, however the bind variable isn't listed.

Select *
  From dual
 Model 
   Dimension by (dummy d)
   Measures ('A' v)
   Rules (
     v['X'] = :val
   );
54 1 / Create an account to join the discussion.
jgar2
Follow / 27 Jun 2017 at 5:45pm / Toad for Oracle
Latest post by on 27 Jun 2017 at 7:33pm

toad variables

Expand content
How do you dynamically get a value into a toad variable. tying to get somthing like this c:\folder1\sub_folder\filename'|| to_char(sysdate,'MM') || '_' || to_char(sysdate...
How do you dynamically get a value into a toad variable.

tying to get somthing like this


c:\folder1\sub_folder\filename'|| to_char(sysdate,'MM')  || '_' || to_char(sysdate,'DD') || '_' || to_char(sysdate,'YYYY') ||'.csv' fqfn from dual;   result:  "c:\folder1\sub_folder\filename_06_27_2017.csv"

I want to use it in email automation.

Unanswered 36 1 / Create an account to join the discussion.
david.fimble
Follow / 27 Jun 2017 at 2:56pm / Toad for Oracle

TOAD/TFS Integration - View Contains Schema Owner in Script

Expand content
We have recently integrated TOAD Beta 12.11.0.82 with TFS. We have unchecked the "Add schema name to VCS file" and we are using the subfolder Structure of "Object Type / <filename>...

We have recently integrated TOAD Beta 12.11.0.82 with TFS.  We have unchecked the "Add schema name to VCS file" and we are using the subfolder Structure of "Object Type / <filename>.  We are then creating a project for each schema, to allow the schema name to not be included in the file name.  It is working great!!!!

The problem that we have is that when VIEWs are checked into TFS, they contain the Schema Owner in the Create View Statement as well as the Schema Owner is included in the COMMENT ON COLUMN statements.  Please note that Packages, Types, and Triggers all do not have the schema owner.  Is there a way to stop this from happening?  When we look at the view script, the schema owner is not included. 

Second, if I have the "Team Coding Manager" View open and I am looking at the "Team Projects" tab, then attempt to drag a View onto the editor, it doesn't work.  Yet the same action with a Package/Type/Trigger all results in that object being editable to me.

Finally, in one of our environments we have a configuration problem that is preventing anything from being checkout from TFS.  So if I try and compile anything, it prompts me if I want to checkout, but the checkout never happens.  The problem I have is that the compile occurs and there is no error that checkout failed.  If I go to "Team Projects" and checkout the object, nothing happens.  No error, no status that it failed.  The only indication that it didn't work, is that the Green Circle did not change to a "checked out" icon.  We are working to figure out why the checkout is failing, but the issue for the product is that the product is not alerting the user to the failure. 

Thanks in advance for taking a look at these items,

David

18 0 / Create an account to join the discussion.
sampathka
Follow / 26 Jun 2017 at 2:27pm / Toad for Oracle
Latest post by on 26 Jun 2017 at 5:03pm

find gaps between numbers

Expand content
query to find gaps between numbers in column of a table
query to find gaps between numbers in column of a table
67 2 / Create an account to join the discussion.
vijayanand.natesan
Follow / 26 Jun 2017 at 9:49am / Toad for Oracle
Latest post by on 26 Jun 2017 at 1:32pm

Toad for oracle 12.5.1.1 says out of memory error

Expand content
Hi All, I have toad for oracle 12.5.1.1 on windows 8.1 with 8 GB RAM. When i try to extract the schema script for a very large Schema and after 3.7 GB , the toad say out of memory error every time even...

Hi All,

                I have toad for oracle 12.5.1.1 on windows 8.1 with 8 GB RAM. When i try to extract the schema script for a very large Schema and after 3.7 GB , the toad say out of memory error  every time even when i re-try it. I have 8 GB and its not trying to use the full memory. Can someone help me out here. Thanks.

73 2 / Create an account to join the discussion.
Joel.Eisenberg
Follow / 9 Dec 2014 at 7:02pm / Toad for Oracle
Latest post by on 26 Jun 2017 at 9:54am

Creating script in Schema Browser of user

Expand content
While connected as sys to a Oracle database and using the schema browser under Toad for ORacle12.6.0.53 I tried to generate a script of a user and nothing happens. If you highlight a user in the schema...
While connected as sys to a Oracle database and using the schema browser under Toad for ORacle12.6.0.53 I tried to generate a script of a user and nothing happens. If you highlight a user in the schema browser and look at the script tab on the right nothing appears. This all worked in Oracle for Toad 12.1.1..... I also found this stopped functioning in 12.5..
13606 5 / Create an account to join the discussion.
anjisiva
Follow / 25 Jun 2017 at 7:46am / Toad for Oracle
Latest post by on 25 Jun 2017 at 12:32pm

ORA-00922: missing or invalid option

Expand content
hi all i am frsher for taod when i am try to execute set serveroutput on command to see output of plsql anonymouse block it is excuting but not showing output. so i am using set serveroutput...
hi all
i am frsher for taod
when i am try to execute set serveroutput on command to see output of plsql anonymouse block
it is excuting but not showing output.
so i am using set serveroutput on it is throwing erro
77 1 / Create an account to join the discussion.
Norm [TeamT]
Follow / 23 Jun 2017 at 2:43pm / Toad for Oracle
Latest post by on 23 Jun 2017 at 5:43pm

Trace File Browser Bugs, Perhaps?

Expand content
Afternoon All, Toad 12.1.0.22. In the Trace File Browser, I have noted the following foibles: In the Statement Details tab, at the top, toggling the "Display Full recursion" context menu...

Afternoon All,

Toad 12.1.0.22.

In the Trace File Browser, I have noted the following foibles:

  • In the Statement Details tab, at the top, toggling the "Display Full recursion" context menu option seems to keep adding the number of CONS READS to the CONS READS INC REC column for some rows in the display. The latter column's value simply increases by the value in the former when the option is toggled. I would expect the values to toggle back and forth between inclusding and excluding the CONS READS value.
  • In the Waits By Object tab, when object_id decoding is not selected, sorting the object_id column doesn't sort by the numeric value of the object_ids, but by their textual values, so you get things like 1,10,100,2,20,200...
  • Also, in the lower half of the screen in the Waits by Object tab, there seems to be a missing context menu option 'Find Statement on Details Tab' which is available on the Wait Summary tab. I have to double-click to get the same effect.
  • In the Query Summary tab, at the top where the trace file summary is displayed with all the various totals etc, I see for some trace files that the last timestamp entry shows "<no timestamps in file>" which is incorrect as there are a good few timestamps in the trace file.
  • Also, in the lower half of the screen in the Query Summary tab, there seems to be a missing context menu option 'Find Statement on Details Tab' which is available on the Wait Summary tab. I have to double-click to get the same effect.
  • In the Query Summary tab, splitting the graph to show user and recursive statements separately causes some bars in the graph to not show a full list of statements when clicked on. I have a 4 statement bar which displays nothing when clicked on - but does display the 4 statements when combined. Another query has 7 statements on the bar, but clicking on it shows only 1. It makes no difference if I click on the user or recursive bars.
  • In the sql statement tab on the lower part of the screen, the bind variable details section seems to sometimes have difficulties extracting bind values for some data types - mainly NUMBER - where the values are displayed as NULL rather than the actual value extracted from the trace file.
  • In the Raw Data tab, in the lower part of the screen, the context menu options Expand All and Collapse All appear to have no effect until you click on an application that is not Toad, then the requested operation suddenly happens. I suspect this is not a Toad foible though, probably a Windows 7 problem that is interfering with Toad - but having said that, it has been consistent today, all day, on numerous trace files.

Finally, I must say how pleased I am with this utility. I have written a little Trace file helper for my own use and it adds data to the end of most of the trace file lines:

  • The 'tim' values are converted to seconds and microseconds by sticking a dot into the number in the appropriate place;
  • There is a new 'delta' value added to show the difference between this 'tim' and the previous 'tim';
  • There is a new 'dslt' value added to show the cumulative delta since the last time stamp record;
  • The 'tim' value is converted into a local, DST aware, date and time.

Toad's Trace File Browser happily copes with these additional fields and shows no ill effects. Most impressive considering that other trace file utilities I have used barf all over the place when they encounter my additions.

If anyone is interested, I have a couple of Trace File utilities on GitHub. Search for TraceAdjust and TraceMiner2 if you are interested. Source code available, help yourselves.

100 4 / Create an account to join the discussion.
llewis79
Follow / 20 Jun 2017 at 6:08pm / Toad for Oracle
Latest post by on 23 Jun 2017 at 4:54pm

Trace File Browser Explanation

Expand content
I have been tasked to create an Intro to Oracle Tracing using the Trace File Browser within Toad. I've search all over the internet trying to find a guide or some sort of tutorial that can explain...

I have been tasked to create an Intro to Oracle Tracing using the Trace File Browser within Toad. I've search all over  the internet trying to find a guide or some sort of tutorial that can explain the tabs on the Trace File Browser for 12.10. Is there any one who can explain/describe what each of those tabs suppose to display or list?? For example, how can one explain what kind of information/data is on the Raw Data tab or the Waits by Object tab.

Answered 193 8 / Create an account to join the discussion.
devnull
Follow / 22 Jun 2017 at 12:44pm / Toad for Oracle
Latest post by on 23 Jun 2017 at 7:51am

Toad Formatter Bug - 12.10.0.30

Expand content
There appears to be a bug in the Toad Formatter when using the ListAgg() function within a Pivot. The formatter does not recognise that "Within Group" is valid and so fails with syntax check...

There appears to be a bug in the Toad Formatter when using the ListAgg() function within a Pivot. The formatter does not recognise that "Within Group" is valid and so fails with syntax check. This can be demonstrated with this simple query.

Select *
  From (    Select 'Cheese' a, Level b
              From Dual
        Connect By Level <= 5)
       Pivot
         (Listagg (b) within        group      (order by 1) for a in ('Cheese'));
47 1 / Create an account to join the discussion.
ServiceAccount_Toad
Follow / 21 Apr 2017 at 4:43pm / Toad for Oracle
Latest post by on 22 Jun 2017 at 9:54am

Visual Studio Online - Team Coding

Expand content
Is there documentation for Team Coding via Visual Studio Online (TFS) using version 12.10.030 of Toad?
Is there documentation for Team Coding via Visual Studio Online (TFS) using version 12.10.030 of Toad?
Unanswered 248 4 / Create an account to join the discussion.
Peter Lang
Follow / 10 Nov 2015 at 3:53pm / Toad for Oracle
Latest post by on 22 Jun 2017 at 9:21am

12.8: What is the button "Commit changes to this connection"...

Expand content
Looks like I choose the wrong button when customizing my toolbars. Both are called "Commit" in the Commands-list and have the same icon. However, they have two different tooltips: Commit Performs...

Looks like I choose the wrong button when customizing my toolbars. Both are called "Commit" in the Commands-list and have the same icon.
However, they have two different tooltips:

Commit
Performs two commits (guess one is at the background-session?)

Commit changes to this connection
Does not seem to do anything, at least according to the Spool SQL window

What is this button for?

Answered 2227 5 / Create an account to join the discussion.
kevin.meade
Follow / 21 Jun 2017 at 6:29pm / Toad for Oracle
Latest post by on 21 Jun 2017 at 7:16pm

two schema snapshots and need to log in to compare?

Expand content
This is not a serious issues but I am curious, why do I need to log into a database first, before I can compare to schema snapshot files? I save a snapshot file for the same schema from two different...
This is not a serious issues but I am curious, why do I need to log into a database first, before I can compare to schema snapshot files?

I save a snapshot file for the same schema from two different databases.  I want to compare them.  There should be no need to log into a database to do this.  But compare schemas is not available unless you log in.  Guess it is just a quirk of the software?

thanks.  Kevin
92 2 / Create an account to join the discussion.
PaulZip
Follow / 21 Jun 2017 at 5:40pm / Toad for Oracle

Clipboard issues in TOAD Editor

Expand content
TOAD v12.10.0.30 - Windows Keyboard based Clipboard (Ctrl-X, C, V) operations in the TOAD editor seem intermittent. Sometimes it works often it doesn't. A similar symptom is seen with Shift based...

TOAD v12.10.0.30 - Windows

Keyboard based Clipboard (Ctrl-X, C, V) operations in the TOAD editor seem intermittent. Sometimes it works often it doesn't.  A similar symptom is seen with Shift based operations, such as capitalising characters.  Only TOAD shows this issue. Other editor applications don't.  I've downloaded a keyboard control code monitoring application and there are no issues with my keyboard.  This is a TOAD issue.

42 0 / Create an account to join the discussion.
ServiceAccount_Toad
Follow / 13 Jun 2017 at 9:29am / Toad for Oracle
Latest post by on 15 Jun 2017 at 1:01pm

Unable to connect to database

Expand content
Hi, Whenever i'm trying to connect to the database, i'm receiving this error "No valid Oracle clients found. You need at least one 64-bit client properly configured." . Kindly help...
Hi,

Whenever i'm trying to connect to the database, i'm receiving this error "No valid Oracle clients found. You need at least one 64-bit client properly configured." . Kindly help me fix it.

Regards
114 1 / Create an account to join the discussion.
Damir Vadas
Follow / 13 Jun 2017 at 10:40am / Toad for Oracle
Latest post by on 14 Jun 2017 at 12:45pm

Bug in recognizing out binds in SQL execution

Expand content
Hi all, Toad 12.11.0.82 beta and last Toad 12.10, all x64 on Oracle 11.2.0.3 x64 Toad cannot run query of type: select count(S.SUBSCRIBER_NO) into :b0:b1 from Problem is ":b0:b1" which toad...

Hi all,
Toad 12.11.0.82 beta and last Toad 12.10, all x64 on Oracle 11.2.0.3 x64

Toad cannot run query of type:
select count(S.SUBSCRIBER_NO) into :b0:b1  from

Problem is ":b0:b1" which toad see as :b0" and error is:
ORA-01036: illegal variable name/number
Brg
Damir

210 8 / Create an account to join the discussion.
ServiceAccount_Toad
Follow / 13 Jun 2017 at 8:04pm / Toad for Oracle
Latest post by on 13 Jun 2017 at 8:24pm

how can i set timeout option in toad?

Expand content
Suppose i have 10 servers and some of them are down. When i am trying to reconnect that server's when reconnection reaches to the down one it waits to much time. how can i skip or set timeout time...
Suppose i have 10 servers and some of them are down. When i am trying to reconnect that server's when reconnection reaches to the down one it  waits to much time. how can i skip or set timeout time for that connection?

Thanks
Unanswered 96 1 / Create an account to join the discussion.
liza.heer
Follow / 26 Jan 2017 at 8:28pm / Toad for Oracle
Latest post by on 13 Jun 2017 at 7:33pm

Navigator Panel

Expand content
I am not sure what happened but I have Toad for Oracle 12.10.0.30 and the navigator panel no longer appears when I drag/drop a new file to open of a .pkb . Thanks in advance for your help.

I am not sure what happened but I have Toad for Oracle 12.10.0.30 and the navigator panel no longer appears when I drag/drop a new file to open of a .pkb .

Thanks in advance for your help.

Unanswered 736 6 / Create an account to join the discussion.