Forums - - Toad for Oracle - Toad World
Jon.Lin
Follow / 8 Sep 2016 at 10:08pm / Toad for Oracle
Latest post by on 26 Jun 2017 at 1:55pm

Latest Release Information

Expand content
Here you can find information on our latest release, from features to downloads & documentation: https://support.quest.com/spotlight-on-oracle

Here you can find information on our latest release, from features to downloads & documentation:

   https://support.quest.com/spotlight-on-oracle

1258 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.

1527 1 / Create an account to join the discussion.
droeschley_109
Follow / 29 Jun 2017 at 6:21pm / Toad for Oracle Beta Program
Latest post by on 21 Jul 2017 at 10:57pm

Compare schema issues

Expand content
I'm comparing an 11g schema to a 12c schema. We've expanded all TIMESTAMP columns from 6 to 9. I've uncheck "Compare column scale, precision, length" but all TIMESTAMP column show...

I'm comparing an 11g schema to a 12c schema.  We've expanded all TIMESTAMP columns from 6 to 9.

I've uncheck "Compare column scale, precision, length" but all TIMESTAMP column show up as differences.  I assume this is because the DATA_TYPE column values have the scale values (6) or (9) embedded, in addition to having the value in the DATA_SCALE column (for whatever reason).  Can the TIMESTAMP scale be eliminated from comparisons when box is unchecked?

Also, my partitioned tables are showing up as differing by "high value, indexing".  These tables do contain timestamp columns, but the List partitioning key is a NUMBER(38) column and the list values are the same.  When I do a Show Differences Detail, the table structure differs (TIMESTAMP scale, BYTE/CHAR for VARCHAR2), but the partition clauses show no differences.

And third, if I select Synonyms, Private, for schema's objects - this schema has 1291 private synonyms defined on it's objects (mostly for the packages) - the compare indicates 664 differences.  When I click to show difference details, there are no differences.  When I show the sync script, it is dropping one user's synonym and adding that synonym to another user.  I've verifies via several queries that there are no differences in private synonyms pointing to object in my schema.

108 6 / Create an account to join the discussion.
antoine_mc1
Follow / 19 Jul 2017 at 9:57pm / Toad for Oracle
Latest post by on 21 Jul 2017 at 8:59pm

DBMS_OUTPUT.PUT_LINE

Expand content
Hello ORACLE community. I can not see the output of the function. This is my script. -- FUNCTION customers( cgetID IN VARCHAR2) RETURN SYS_REFCURSOR; -- -- SET SERVEROUTPUT ON SIZE 30000; DECLARE vSRef...

Hello ORACLE community.
I can not see the output of the function.
This is my script.

-- FUNCTION customers( cgetID IN VARCHAR2) RETURN SYS_REFCURSOR;
--
--

SET SERVEROUTPUT ON SIZE 30000;
DECLARE
vSRef SYS_REFCURSOR;
BEGIN
vSRef:=PACKAGE_CLIENTS.customers('130');
DBMS_OUTPUT.PUT_LINE(vSRef);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('ERROR:'||sqlerrm);
END;

I have the error:
PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'

Could you help me please. Thanks a lot!

:)

Unanswered 231 9 / Create an account to join the discussion.
Piotr
Follow / 21 Jul 2017 at 11:35am / Toad for Oracle
Latest post by on 21 Jul 2017 at 4:02pm

TOAD 12.11 new features missing

Expand content
Going over "new features" in release notes for Toad for Oracle 12.11 I'm failing to find some of them: "A new Session | Transactions feature enables you to determine whether open...

Going over "new features" in release notes for Toad for Oracle 12.11 I'm failing to find some of them:

  • "A new Session | Transactions feature enables you to determine whether open sessions are performing a transaction." - Can't find this in Session menu.

  • "The new Compare Multiple Tables feature allows you to compare and synchronize multiple tables between two schemas. To use this feature, select Database | Compare | Compare Multiple Tables or click in the Automation Designer." - again, no such entry in Database | Compare menu.

  • "Database | Compare | Schemas now supports the use of DBMS_REDEFINITION to sync tables that are missing a column that is in the middle of the table." I can see only "Schemas - Legacy" option in Database | Compare menu. ?
Answered 57 2 / Create an account to join the discussion.