Danny Torres
Follow / 14 Sep 2016 at 5:03pm / Toad for Oracle
Latest post by on 28 Nov 2017 at 6:27pm

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 Quest Support

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

Quest Web Support

This opens Quest 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. 

Release Information: 

Here are some key links: 

  • Link to Documentation:

https://support.quest.com/toad-for-oracle        

(Release Notes includes latest release enhancements; Installation Guide includes pre-requisites; Getting Started includes product features) 

  • Link to Downloads (existing customers):

https://support.quest.com/toad-for-oracle/download-new-releases 

  • Link to Trial (new customers):

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

  • Knowledge Base Articles:

https://support.quest.com/toad-for-oracle/kb 

The Support Knowledge Base includes Videos, Tutorials, and other information intended to help users.

Feel free to browse the knowledge base articles. Remember to sign in to your account to view.

5750 3 / Create an account to join the discussion.
raul.kaubi
Follow / 19 Jul 2018 at 2:59pm / Toad for Oracle
Latest post by on 20 Jul 2018 at 3:14pm

Toad for Oracle: User cannot open procedures/functions tabs - ORA...

Expand content
Hi Toad for Oracle 12.12.0.39 Oracle 10.2.0.5.0 I noticed that user cannot open even his own schema procedures or functions tabs. "ORA-00942: table or view does not exists" I have granted...

Hi

Toad for Oracle 12.12.0.39
Oracle 10.2.0.5.0

I noticed that user cannot open even his own schema procedures or functions tabs.

"ORA-00942: table or view does not exists"

I have granted "execute any procedure". But in my own schema, I do not need this grant also. 

What I can see is other schema packages for instance. So this grant "execute any procedure" indeed works.

Problem looks to be only with 10g databases.

Is there something I can do without upgrading to toad 13 at the moment..? (additional grant perhaps..?)

Or is there a syntax error in these two queries..?

Regards
Raul

0 3 / Create an account to join the discussion.
prakash.chada
Follow / 19 Jul 2018 at 5:26pm / Toad for Oracle
Latest post by on 19 Jul 2018 at 6:48pm

Output From TOAD for Oracle

Expand content
Hi, I am running a query in Toad. Produces 2 sets of results. Grid1 and Grid2 When I export Grid1 or Grid2 to Excel, it picks up ALL data grids into one file. Is there a way to export one Grid at a time...

Hi,
I am running a query in Toad. Produces 2 sets of results. Grid1 and Grid2
When I export Grid1 or Grid2 to Excel, it picks up ALL data grids into one file.

Is there a way to export one Grid at a time?

Thank you.

0 1 / Create an account to join the discussion.
david.fimble
Follow / 13 Jul 2018 at 2:44pm / Toad for Oracle
Latest post by on 19 Jul 2018 at 1:50pm

Compare Schemas: Difference Details Tab - Detail View

Expand content
One of the features of the older TOAD's comparison tool was that it allowed for the details of the comparison to be seen. This made it easier to see exactly differences were being addressed by each...

One of the features of the older TOAD's comparison tool was that it allowed for the details of the comparison to be seen.  This made it easier to see exactly differences were being addressed by each of the items.  In the current Compare Schema, the functionality to see the details is there, but it requires a mouse click to pop-up the screen, and another to remove the screen.  When each difference is being reviewed and there are hundreds of differences, this makes the review process take much longer than required.

What I would like to see changed is on the "Difference Details" tab, to make the it into a split screen, such that the existing Tree View would be displayed on the left hand side, and on the right hand side that two more panes be displayed with right top pane containing the detail view and the bottom pane showing the DDL Script.  This would eliminate streamline the review process and drastically reduce the amount of effort required for large reviews.

On a separate topic, TOAD is currently not supporting an automated approach to re-order columns of a table if DBMS_REDIFINITION is not available.  (our DBAs will not allow us to use the DBMS_REDIFINITION package because of security concerns).  What I would like to see is an option that would create a script like this:  Rename Table to some temp name, drop all triggers, FK, indexes etc from the table, create table using correct ordering of columns, add indexes, triggers, FK, etc.  These are the steps that we are doing manually.  Obviously, the DBMS_REDIFINITION package would be the preferred approach is it doesn't require downtime, but at least if this were a choice, then the manual work to recreate the table could be eliminated.

Thanks for listening and love the tool!

David

105 3 / Create an account to join the discussion.
antoine_mc1
Follow / 9 Jul 2018 at 5:05am / Toad for Oracle
Latest post by on 19 Jul 2018 at 1:46pm

Bind Variable "cursorMemoria" is NOT DECLARED

Expand content
hello, I have the next example: create or replace procedure listaEmpleados(cursorMemoria OUT SYS_REFCURSOR) as BEGIN open CURSORMEMORIA for select * from HR.EMPLOYEES; DBMS_OUTPUT.ENABLE(1000000...

hello,

I have the next example: 

create or replace procedure listaEmpleados(cursorMemoria OUT SYS_REFCURSOR)
as
BEGIN
open CURSORMEMORIA for select * from HR.EMPLOYEES;
DBMS_OUTPUT.ENABLE(1000000);
END;

set AUTOPRINT on;

VARIABLE cursorMemoria SYS_REFCURSOR;
EXECUTE listaEmpleados(:cursorMemoria);

But I have the Bind Variable "cursorMemoria" is NOT DECLARED.   Please could you help me.  Thank you.

Usage: VAR[IABLE] [ <variable> [ NUMBER | CHAR | CHAR (n [CHAR|BYTE]) |

VARCHAR2 (n [CHAR|BYTE]) | NCHAR | NCHAR (n) |
NVARCHAR2 (n) | CLOB | NCLOB | REFCURSOR |
BINARY_FLOAT | BINARY_DOUBLE ] ]

Bind Variable "cursorMemoria" is NOT DECLARED
anonymous block completed

Unanswered 207 2 / Create an account to join the discussion.
Norm [TeamT]
Follow / 19 Jul 2018 at 1:18pm / Toad for Oracle
Latest post by on 19 Jul 2018 at 1:21pm

Minor Bug in the Trace File Browser

Expand content
Hi John (I'm assuming that it will be you who gets this!) TOAD 13.0.0.80 64bit With DB Admin Module. Windows 7 64bit Oracle 11.2.0.4 on AIX. I was using the trace file browser to look at...

Hi John (I'm assuming that it will be you who gets this!)

  • TOAD 13.0.0.80 64bit With DB Admin Module.
  • Windows 7 64bit
  • Oracle 11.2.0.4 on AIX.

I was using  the trace file browser to look at a trace file, and I noticed a slight foible. I've attached, hopefully, a small trace that shows the problem. Server names etc have been obfuscated to protect me!

In the TFB, lower panel, SQL Statement tab, bind details on the left side, one of the binds is listed as having a NULL value, when in fact it is a varchar2 with a data format string in it. However, if I look on the right side, and check to "substitute variables back into SQL" then it does appear with the correct value.

This contrived statement shows the problem:

select to_char(to_date(:dte, :fmt), :fmt) from dual

It is, of course, a minor problem.

Cheers,

Norm. [TeamT]

0 1 / Create an account to join the discussion.
Guest
Follow / 19 Oct 2010 at 5:28pm / Toad for Oracle
Latest post by on 19 Jul 2018 at 5:57am

Data Grid Sizing

Expand content
Good Morning; I’ll bet I’m missing something obvious. Toad 10.6.0.42. Issue, when I run a query all columns appear compressed and I get to mess around with resizing in order to see both data...

Good Morning;

I’ll bet I’m missing something obvious. Toad 10.6.0.42.

Issue, when I run a query all columns appear compressed and I get to mess around
with resizing in order to see both data and headers.

I’ve the following settings:

Data Grids -> Visual -> Column Sizing -> Size to Data – selected

Data Grids -> Visual -> Column Sizing -> Min column size: 30

I’ve even restarted Toad after saving the settings and the columns are
still compressed.

For example, I have one field called Status, value “Approved”. What
shows up in the data grid is:

Header: STAT…

Data: APPR

The compression appears to be consistent across all character fields, only the
first four values are shown.

Question: What setting(s) do I need to change in order to see the full header
plus the full data?

It’s almost like the default column width is a fixed size and then you get
to resize it differently after that. Just eyeballing the 10 columns that show up
on the screen appear to be a consistent width in all the columns.

Thanks!

Roger A. Simoneau
Alberta Blue Cross
(780)498-8837

26690 11 / Create an account to join the discussion.
zajac
Follow / 17 Jul 2018 at 5:09pm / Toad for Oracle
Latest post by on 18 Jul 2018 at 9:34pm

Cannot open the selected Model. The file "C:\Path_Name\File_Name...

Expand content
How do I solve the error "Cannot open the selected Model. The file "C:\Path_Name\File_Name.qbx" has unknown content." Some one asked this same question in this post but did not get...

How do I solve the error "Cannot open the selected Model. The file "C:\Path_Name\File_Name.qbx" has unknown content." Some one asked this same question in this post  but did not get a response or answer. I have been unable to successfuly reopen a a model since I started using Toad for Oracle several months ago. 

Oracle DBA Edition 2018 v13.0.0.80

Win 10 Pro v1703 build 15063.1088

Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

Unanswered 62 4 / Create an account to join the discussion.
Jorley
Follow / 18 Jul 2018 at 3:47pm / Toad for Oracle
Latest post by on 18 Jul 2018 at 4:49pm

Comparing schema's - what's the difference between recompare...

Expand content
Hi, I was wondering what the difference was between recompare selected (at the top) and the run button (at the bottom) ? When I manually check for differences and also manually correct them (so not...

Hi,

I was wondering what the difference was between recompare selected (at the top) and the run button (at the bottom) ?

When I manually check for differences and also manually correct them (so not via script) then it looks like the recompare still shows it as difference, while the run button removes it from the list (like expected).

Are there any issues with this? Anyone having the same problem?

Kind regards

0 1 / Create an account to join the discussion.
Trant3
Follow / 18 Jul 2018 at 2:45am / Toad for Oracle
Latest post by on 18 Jul 2018 at 3:50pm

Object Pallet is blank

Expand content
Hello everyone I don't know what I did but now whenever I decide to view the object palette, there is nothing in there and I can't find anything that is obvious to help to restore to previous...

Hello everyone

I don't know what I did but now whenever I decide to view the object palette, there is nothing in there

and I can't find anything that is obvious to help to restore to previous setting where you will see tables/views in different schemas

Any help is appreciate

TT

0 1 / Create an account to join the discussion.
sergio.valle
Follow / 18 Jul 2018 at 3:48pm / Toad for Oracle

Toad 13.0.0.80 : if you visualize a tablespace and you need to visualize...

Expand content
In Toad 1212 all is ok. We spooled the relative code when we did the operation. In Toad 13.0 only we saw this as last action : select space from sys.dba_recyclebin where space is not null and space...

In Toad 1212 all is ok.

We spooled the relative code when we did the operation.

In Toad 13.0 only we saw this as last action :

select space
from sys.dba_recyclebin
where space is not null
and space > 0
and ts_name = '<tablespace name>';

Why so ? What's the use ?

Thank you

p.s. in older releases like 9i and 8i recyclebin do not exist … and we still have some old releases ...

0 0 / Create an account to join the discussion.
david.fimble
Follow / 13 Jul 2018 at 2:19pm / Toad for Oracle
Latest post by on 16 Jul 2018 at 4:32pm

Load Database Object - Grid Display is empty

Expand content
Whenever I open the "Load Database Object" and select "TRIGGER", the contents of the triggers is now shown. In the screen print below I have "grouped" by Type to show that...

Whenever I open the "Load Database Object" and select "TRIGGER", the contents of the triggers is now shown.  In the screen print below I have "grouped" by Type to show that there 28 triggers which should be displayed.  The same issue occurs even if I am not grouping by Type.  Resizing the screen resolves the display issue.

The issue seems to have started once I started using the Beta release.  I'm currently using 13.1.0.25.

Thanks,
David

124 2 / Create an account to join the discussion.
david.fimble
Follow / 13 Jul 2018 at 2:28pm / Toad for Oracle

Export Dataset: Insert Statements - Automatic Schema and Name Log...

Expand content
With Export Dataset window, when setting the Export Format to "Insert Statements", the screen always defaults to "Automatically detect schema and name". It would be nice if the tool...

With Export Dataset window, when setting the Export Format to "Insert Statements", the screen always defaults to "Automatically detect schema and name".  It would be nice if the tool could remember my preference to not automatically remember the schema name.  One way to implement this would be to change the Check Box to a Radio Button, and add two selection options of:  "Automatically detect name"  or "No Automatic Detection".  In this way, my preference of "Automatically detect name" could be defaulted eliminating a manual step.

Thanks,

David

77 0 / Create an account to join the discussion.
david.fimble
Follow / 13 Jul 2018 at 2:14pm / Toad for Oracle

EDITOR RULE: Not applied consistently

Expand content
In the below screen print, it shows that RULE 3801 is not being followed. If I uncomment the line 1196, then there is RULE violation. The issue is that a RAISE and a RAISE_APPLICATION_ERROR should be treated...

In the below screen print, it shows that RULE 3801 is not being followed.  If I uncomment the line 1196, then there is RULE violation.  The issue is that a RAISE and a RAISE_APPLICATION_ERROR should be treated as the same so that the RULE behavior is the same.

74 0 / Create an account to join the discussion.
Guest
Follow / 9 Feb 2010 at 11:13pm / Toad for Oracle
Latest post by on 12 Jul 2018 at 9:24pm

Avoid ORA-03113: end-of-file on comm channel? Timeout?

Expand content
When clicking Toad menues after a while of inactivity (~ > 20 minutes) I am getting frequently error popups telling me: ORA-03113: end-of-file on communication channel Is this a timeout problem? if...

When clicking Toad menues after a while of inactivity (~ > 20 minutes) I am
getting frequently
error popups telling me:

ORA-03113: end-of-file on communication channel

Is this a timeout problem?

if yes: From Toad or Oracle DB?

Can I avoid this somehow?

Are there keep alive messages form Toad to Oracle available?

Ben
--
View this message in context: http://old.nabble.com/Avoid-ORA-03113%3A-end-of-file-on-comm-channel--Timeout--tp27522157p27522157.html
Sent from the TOAD mailing list archive at Nabble.com.

16692 4 / Create an account to join the discussion.
Norm [TeamT]
Follow / 12 Jul 2018 at 1:36pm / Toad for Oracle

Generating ERD diagrams from SQL Scripts

Expand content
Afternoon All, someone might find this useful. It's a mirror of one of my blog postings on Community.toadworld.com - https://community.toadworld.com/platforms/oracle/b/weblog/archive/2018/07/12...

Afternoon All,

someone might find this useful. It's a mirror of one of my blog postings on Community.toadworld.com - https://community.toadworld.com/platforms/oracle/b/weblog/archive/2018/07/12/generate-entity-relationship-diagrams-from-a-sql-script - where you can see how to generate a diagram of the ERD around and about a single table, using a script and the graphviz utility. Handy for those occasions when you find yourself on site, with no ERD diagram and work to do!

The original posting is on my blog at http://qdosmsq.dunbar-it.co.uk/blog/2018/07/generate-entity-relationship-diagrams-from-a-sql-script/ (but only because sometimes, the miro on Toad World corrupts code listings!)

82 0 / Create an account to join the discussion.
sdstuber
Follow / 11 Jul 2018 at 8:48pm / Toad for Oracle
Latest post by on 11 Jul 2018 at 9:06pm

18c client and LDAP connection dropdown

Expand content
Even though the client is 18c, it appears Toad is looking for oraldapclnt12.dll in order to populate the connection dropdown list. My work around was to simply copy the oraldapclnt18.dll to oraldapclnt12...

Even though the client is 18c, it appears Toad is looking for oraldapclnt12.dll  in order to populate the connection dropdown list.

My work around was to simply copy the oraldapclnt18.dll to oraldapclnt12.dll and restart.

Is there a better way?  I assume this will be fixed in a future release (if it's not already?)

Answered 182 2 / Create an account to join the discussion.
bricot_750
Follow / 16 Nov 2012 at 12:43am / Toad for Oracle
Latest post by on 11 Jul 2018 at 4:58pm

Toad highlights text that is repeated, can you change it easily?

Expand content
When you have the same text in the same sql statement or multiple statements in the same window and highlight one occurence of that text toad will automatically highlight all the occurences of it. Is there...
When you have the same text in the same sql statement or multiple statements in the same window and highlight one occurence of that text toad will automatically highlight all the occurences of it.  Is there a slick way of changing all of those highlighted instances using that feature?  Seems like you should be able to do something like double click the text to select, toad then highlights any matches, you should be able to right click one of the highlighted occurences and pick something like change selected ....
13430 4 / Create an account to join the discussion.
Samhita
Follow / 9 Jul 2018 at 11:18am / Toad for Oracle
Latest post by on 11 Jul 2018 at 4:46pm

Integrate Git with Toad V 9.6.0.27

Expand content
Hello, We are using Toad for Oracle Version 9.6.0.27 with Oracle 11g Client. Can you suggest ways of integrating git with this version of Toad. I came across few blogposts showing for Toad Version 12...

Hello,

We are using Toad for Oracle Version 9.6.0.27 with Oracle 11g Client. Can you suggest ways of integrating git with this version of Toad. I came across few blogposts showing for Toad Version 12. 

Please suggest how to integrate Git with Toad V 9.6.0.27.

Thanks,

Samhita

Unanswered 192 1 / Create an account to join the discussion.
Jonny1
Follow / 4 Jul 2014 at 1:11pm / Toad for Oracle
Latest post by on 11 Jul 2018 at 4:45pm

Toad and Git for historical code changes

Expand content
Hi, This is my first post. I'm new to Toad and we currently don't have any kind of versioning in place. I have suggested we use Git so was pleased to see that you have Git built in. Currently...

Hi,

This is my first post. I'm new to Toad and we currently don't have any kind of versioning in place. I have suggested we use Git so was pleased to see that you have Git built in. Currently, it's a very small team and we do a lot of testing in our testing server (in Toad) before deploying to our live sever through Toad. The only problem here is that we can't track how the code has changed. Much as we're sure that the new code works and does what it's meant to be doing we have no way to track how the code has changed over time, which would be good to help identify how the business goals changed and things like that. What I was hoping to do was basically use Git through Toad as a way to track how our SQL code has changed, as it's a very small team it's highly unlikely we will both be working on the very same file at the same time, in fact we all have completely separate areas of focus. So would this be possible through Toad, I was hoping for basically Toad to just push a file every time it's altered automatically, meaning that in 6 months time someone could come in and say "Oh, this was the code, but it changed on this date due to x,y,z" kind of thing. Is that possible?

Thanks

Answered 12863 4 / Create an account to join the discussion.