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.

1636 1 / Create an account to join the discussion.
smattiko83
Follow / 18 Aug 2017 at 8:13pm / Toad for Oracle
Latest post by on 18 Aug 2017 at 9:18pm

Choose data type when importing

Expand content
How do I choose the data type I want when importing a txt file or excel file? Thanks.

How do I choose the data type I want when importing a txt file or excel file?

Thanks.

64 1 / Create an account to join the discussion.
PaulZip
Follow / 18 Aug 2017 at 3:48pm / Toad for Oracle
Latest post by on 18 Aug 2017 at 5:15pm

Go to matching parenthesis in editor?

Expand content
v 12.11.0.95 Is there any way to go to the matching parenthesis in TOAD in the editor? So if on (, it'll take you to the matching ) or vice versa via some key press? I know the syntax highlighter...

v 12.11.0.95

Is there any way to go to the matching parenthesis in TOAD in the editor?  So if on (, it'll take you to the matching ) or vice versa via some key press?  I know the syntax highlighter will show it, but this is next to useless for things like when you are writing say huge blocks of XML DB code, which has lots of nesting parenthesis and you want to go to where the XMLElement, or XMLAgg is closed.

Unanswered 53 1 / Create an account to join the discussion.
JayGBardo1
Follow / 18 Aug 2017 at 3:17pm / Toad for Oracle
Latest post by on 18 Aug 2017 at 5:11pm

SQL Loader Location Required

Expand content
I am doing some development for a company, and the gave me TOAD 9.7.2 for the Oracle "back-end" develop of an MS ACCESS application. I need to use SQL * Loader. When I create the Control file...

I am doing some development for a company, and the gave me TOAD 9.7.2 for the Oracle "back-end" develop of an MS ACCESS application.

I need to use SQL * Loader. When I create the Control file through the TOAD interface, it say "Location of SQL*Loader Required".

I look in the options and there paths for about a dozen utility, and SQL * Loader is one of them. However the path is blank and AutoFind does not find the Executable.

I haven't used toad before but I think the didn't install SQL * Loader...

Is that typical? So I perhaps I have to put in a request...

Any thoughts?

77 1 / Create an account to join the discussion.
john.c.rose
Follow / 18 Aug 2017 at 4:14pm / Toad for Oracle
Latest post by on 18 Aug 2017 at 4:22pm

Automation Designer & Windows Task Scheduler

Expand content
TOAD 12.11.0.95 ~ Oracle 12.1.0.2.0 Due to business rules, I am not able to schedule a TOAD automation app using Windows Task Scheduler from within TOAD. It is required that I launch Windows Task Scheduler...

TOAD 12.11.0.95 ~ Oracle 12.1.0.2.0

Due to business rules, I am not able to schedule a TOAD automation app using Windows Task Scheduler from within TOAD.  It is required that I launch Windows Task Scheduler as admin then set up the new scheduled task.

 

The new app and action are set up and run fine within TOAD. The need is to set it up on a weekly schedule.   I am unable to locate the task that TOAD has saved to set it up within the Windows Scheduler.

 

The Change User option in TOAD will not work because the admin user account is controlled exclusively by smart card. I have searched the C:\ drive for the app name and the action/task name and came up empty. I did find a TOAD folder in windows>system 32>tasks>quest software but that folder is empty. Also drilled down to the user folder within program files(86) toad and found no likely suspects.

 

When I try to use the scheduler via TOAD automation designer, at the very end of the process toad pops up an error messages stating an undisclosed error has occurred. Local security rules mandate all windows task schedules be created with advanced privileges which the admin account carries..

 

Can someone point me to where I might locate the saved TOAD app/task/action? I think that is my only option to get a weekly task set up in TOAD via the windows scheduler.

Any and all pointers & suggestions appreciated.

39 1 / Create an account to join the discussion.
OVIDIU T.
Follow / 17 Aug 2017 at 6:58pm / Toad for Oracle
Latest post by on 17 Aug 2017 at 7:52pm

Export from Toad into Excel is not preserving the "new line"...

Expand content
I'm trying to Export some data into an Excel. Some of the fields have aggregated values which are separated by "new lines" - chr(13). (I've also tried chr(10) and chr(13)||chr(10) ...

I'm trying to Export some data into an Excel.

Some of the fields have aggregated values which are separated by "new lines" - chr(13). (I've also tried chr(10) and chr(13)||chr(10) )

Everything looks good in Toad (grid view).

But the export to Excel does not preserve the "new lines" They are essential for the formatting in my particular case.

Is this a bug? I can't find any option that would control this behavior.

Thoughts?
Thanks!

76 4 / Create an account to join the discussion.
Naveen Kori
Follow / 21 Jan 2016 at 3:46am / Toad for Oracle
Latest post by on 17 Aug 2017 at 4:27pm

Unable to load Toad - Stream read error

Expand content
Hi Guys, I am having trouble while opening Toad 10, I am receiving the error "Stream read error" Please find the error code below, If anyone could help me that would be great!! 2.1 Date...

Hi Guys,

I am having trouble while opening Toad 10, I am receiving the error "Stream read error"

Please find the error code below, If anyone could help me that would be great!!

2.1 Date : Thu, 21 Jan 2016 09:16:56 +0600

2.2 Address : 0043B145

2.3 Module Name : Toad.exe - (Toad for Oracle)

2.4 Module Version: 10.0.0.41

2.5 Type : EReadError

2.6 Message : Stream read error.

2.7 ID : 0059

2.8 Count : 1

2.9 Status : New

2.10 Note :

 

Thanks,

Naveen Kori

Unanswered 7067 11 / Create an account to join the discussion.
roumen
Follow / 16 Aug 2017 at 4:21pm / Toad for Oracle
Latest post by on 17 Aug 2017 at 1:47pm

Cannot see USERS Tab in Toad 11.6 for Oracle DB 12c

Expand content
I have different Oracle DB versions with which I work with Toad 11.6 - 10.2, 11.2 and 12.1. The problem is that when I access the Users tab on the Oracle DB 12.1 I am getting the following error message...

I have different Oracle DB versions with which I work with Toad 11.6 - 10.2, 11.2 and 12.1. The problem is that when I access the Users tab on the Oracle DB 12.1 I am getting the following error message:

ORA-01841: (full) year must be between -4713 and +9999 and not be 0

I was able to figure out that it is caused by the new filed LAST_LOGIN introduced in Oracle DB 12c in dba_users, which was not existing in previous Oracle DB versions. I spooled SQL and found taht when I go to Users tab Toad executes this query:

Select u.*, v.*
from sys.DBA_USERS u, sys.v_$pwfile_users v
where 1=1
and u.username = v.username(+)

What can I do in order to be able to see users in the Users tab in Toad 11.6 for the Oracle 12c databases? For other versions of Oracle databases that I work with I don't have this problem. Shall I put any filter on displaying Users tab or maybe to amend the above query somehow and make Toad to execute the amended query  instead the above mentioned? 

Thank you!

72 3 / Create an account to join the discussion.
rust
Follow / 11 Aug 2017 at 2:40pm / Toad for Oracle
Latest post by on 16 Aug 2017 at 8:25pm

sqlplus script exit

Expand content
Hello, I want to start a script in SQLPLUS. If the login of HOST_NAME <> 'IM333', the script may continue. But I do not know how I define a query and the script in the <> case...
Hello,
I want to start a script in SQLPLUS. If the login of HOST_NAME <> 'IM333', the script may continue.

But I do not know how I define a query and the script in the <> case is terminated.

So I ask for help. Many Thanks.

André


REM sqlplus USER/PASSWORD@DATABASE

COL HOSTNAME NEW_VALUE HNAME
COL HOSTNAME_WERT NEW_VALUE HNAMEW

SELECT HOST_NAME AS HOSTNAME,
      DECODE( HOST_NAME, 'IM333', 0, 1 ) AS HOSTNAME_WERT
 FROM V$INSTANCE;

??




Answered 387 24 / Create an account to join the discussion.
ServiceAccount_Toad
Follow / 16 Aug 2017 at 8:02pm / Toad for Oracle
Latest post by on 16 Aug 2017 at 8:17pm

Toad configurations on Windows 7

Expand content
Hi, I have Toad installed on windows 7 64 bit and have 11g client installed which TOAD recognizes and see all TNS entries from it. I installed 12.2 client and update all my system variables (ORACLE_HOME...
Hi,

I have Toad installed on windows 7 64 bit and have 11g client installed which TOAD recognizes and see all TNS entries from it. I installed 12.2 client and update all my system variables (ORACLE_HOME, PATH, TNS_ADMIN) to new client location but TOAD still identifies the 11g client and reads from it. How can I use 12.2 client with Toad?
Unanswered 58 1 / Create an account to join the discussion.
MStoeber
Follow / 14 Aug 2017 at 3:14pm / Toad for Oracle
Latest post by on 16 Aug 2017 at 3:48pm

Automation Designer - Using file in email body

Expand content
Hello, Im currently running "Toad For Oracle Xpert x64 Version 12.11.0.95" and am looking for a way to use a file output as the body of an email sent out each morning using the automation designer...

Hello,

Im currently running "Toad For Oracle Xpert x64 Version 12.11.0.95" and am looking for a way to use a file output as the body of an email sent out each morning using the automation designer. Ive watched many tutorials and done a lot of searching (For example, here) and it looks pretty straight forward. Im running the latest version of Toad though and I dont have nearly as many options.

Below is an example of the very basic functions that Im able to access. How can I use a file in the email body using the below?

Thanks,

Matt

Unanswered 67 4 / Create an account to join the discussion.
chazamania
Follow / 16 Aug 2017 at 11:16am / Toad for Oracle
Latest post by on 16 Aug 2017 at 1:35pm

Toad 12.11 ORA-02248 on datafile maintenance (add/alter) in Oracle...

Expand content
I saw a similar thread on the beta forum. It performs the desired change, but always ends with the error. It just started in 12.11. Spooled SQL: ALTER DATABASE DATAFILE '/db01/ORACLE/tundaimx/system01...

I saw a similar thread on the beta forum. It performs the desired change, but always ends with the error. It just started in 12.11. 

Spooled SQL:

 
ALTER DATABASE
DATAFILE '/db01/ORACLE/tundaimx/system01.dbf'
AUTOEXTEND ON
NEXT 1M
MAXSIZE 8G;

ALTER SESSION SET CONTAINER =;
Error: ORA-02248: invalid option for ALTER SESSION

57 1 / Create an account to join the discussion.
ty.cheng
Follow / 11 Aug 2017 at 3:04am / Toad for Oracle
Latest post by on 16 Aug 2017 at 8:10am

How to speed up schema browser using toad for oracle 12c database...

Expand content
I am having problem with slowness when using schema browsing in oracle 12c database and i just wondering have any one out there found a resolution to this issue. I have been put up with this issue for...

I am having problem with slowness when using schema browsing in oracle 12c database and i just wondering have any one out there found a resolution to this issue. I have been put up with this issue for almost two years now.

315 22 / Create an account to join the discussion.
Damir Vadas
Follow / 15 Aug 2017 at 9:10am / Toad for Oracle
Latest post by on 15 Aug 2017 at 8:38pm

Posting on forum

Expand content
Hi many times when i place edited version of mine post or two posts under several minutes I get: and sometimes mine reply is not visible on forum, but other users reply on it. it is also very bad...

Hi many times when i place edited version of mine post or two posts under several minutes I get:

and sometimes mine reply is not visible on forum, but other users reply on it.

it is also very bad when I reply on hours when there is noone in America (I am on GMT+1) so to see the reply 5-6 hours need to pass.

Is there any way to make more "easy" this security checking. At least to put some users away from checking?

Brg

Damir

Unanswered 83 2 / Create an account to join the discussion.
antoine_mc1
Follow / 11 Aug 2017 at 6:02pm / Toad for Oracle
Latest post by on 13 Aug 2017 at 7:54pm

Three rows inserted in a field

Expand content
The topic is the field receives 3 rows from other tables I want to insert a row from a first table and two rows from a second table, and are inserted into a third table but in a single field. The field...

The topic is the field receives 3 rows from other tables

I want to insert a row from a first table and two rows from a second table, and are inserted into a third table but in a single field.

The field receives the three complete rows.

The status field receives the 3 rows

I have the following error:

ORA-01427: Single row subquery returns more than one row

Do I insert the 3 rows into a single field?

INSERT INTO tablac3

(historico, iduno, codigouno, numero, clave, nombreEjecutivo, fecha, modo, status )

VALUES

(lasecuencia.nextval, 22, 'TEST', 'qaz123', 'edc456', 'paquita', '11/06/2017', 'rfv',

(select C.Nombre from tablita c, tablota p WHERE c.identificador = 5 AND p.identificador = 5) );  

thank you

Unanswered 63 1 / Create an account to join the discussion.
JayGBardo1
Follow / 11 Aug 2017 at 6:10pm / Toad for Oracle
Latest post by on 13 Aug 2017 at 9:09am

TRIGGERS

Expand content
I am attempting Autonumber the records in Oracle Table ID is primary key When I insert a new row, I want the new row to have the next sequential number. old row ID = 100 new row ID (is to = 101...

I am attempting Autonumber the records in Oracle Table

ID is primary key

When I insert a new row, I want the new row to have the next sequential number.

old row ID = 100

new row ID (is to = 101) before insert

In creating a trigger the following code gets generated.

CREATE OR REPLACE TRIGGER DOBS.my_trigger1

BEFORE INSERT

ON DOBS.LK_PRODUCT_NDC_MAPPING

REFERENCING NEW AS New OLD AS Old

FOR EACH ROW

DECLARE

tmpVar NUMBER;

/******************************************************************************

NAME:

PURPOSE:

REVISIONS:

Ver Date Author Description

--------- ---------- --------------- ------------------------------------

1.0 8/11/2017 1. Created this trigger.

NOTES:

Automatically available Auto Replace Keywords:

Object Name:

Sysdate: 8/11/2017

Date and Time: 8/11/2017, 12:06:08 PM, and 8/11/2017 12:06:08 PM

Username: (set in TOAD Options, Proc Templates)

Table Name: LK_PRODUCT_NDC_MAPPING (set in the "New PL/SQL Object" dialog)

Trigger Options: (set in the "New PL/SQL Object" dialog)

******************************************************************************/

BEGIN

tmpVar := 0;

SELECT MySeq.NEXTVAL INTO tmpVar FROM dual;

:NEW.SequenceColumn := tmpVar;

:NEW.CreatedDate := SYSDATE;

:NEW.CreatedUser := USER;

EXCEPTION

WHEN OTHERS THEN

-- Consider logging the error and then re-raise

RAISE;

END ;

QUESTION: Do I edit the code change SequenceColumn to ID?

It appears that this has to be edit and then saved.

I don't need to update the other fields. Those appear to be "examples".

Could someone confirm this?

Thanks.

JayGBardo1

83 3 / Create an account to join the discussion.
statey603
Follow / 11 Aug 2017 at 4:24pm / Toad for Oracle
Latest post by on 11 Aug 2017 at 7:47pm

Recently upgraded to 12.10, imported 12.5 settings, Editor formatting...

Expand content
I recently upgrade to Toad For Oracle 12.10. I previously had 12.5. Prior to the upgrade I saved my 12.5 Toad settings. After upgrade I imported them. I noticed many things changed with the settings in...

I recently upgrade to Toad For Oracle 12.10. I previously had 12.5. Prior to the upgrade I saved my 12.5 Toad settings. After upgrade I imported them. I noticed many things changed with the settings in general - items moved, changed names, etc, like Syntax highlighting

Anyway, I just opened an Oracle package that I had been working on and the formatting is all screwed up. Script is indented much further than it was originally and extra spaces in whitespace areas. I never used auto-indent or tabs in my code, just simple 2 spaces for indent. Not my code is hard to read. 

I am trying to figure out if there is some new setting(s) that somehow overrode the settings that I used to use that might have caused this reformatting of my code.

If anyone can shed some light on this I would appreciate it.

83 3 / Create an account to join the discussion.
david.fimble
Follow / 7 Aug 2017 at 1:55pm / Toad for Oracle
Latest post by on 11 Aug 2017 at 4:34pm

TOAD - Hang & Issue with Wipe User Settings

Expand content
I am having a problem with TOAD in which about 30 seconds, the application becomes unresponsive. Other applications that I am using work fine, but TOAD just hangs. I tried to "Reset to a clean set...

I am having a problem with TOAD in which about 30 seconds, the application becomes unresponsive.  Other applications that I am using work fine, but TOAD just hangs.  I tried to "Reset to a clean set of user files from the base installation", but it complained about files being read only.

I then went to my TOAD User Files folder and I deleted all of the INI files.  (Created a backup just in case).  I was able to start TOAD, but I don't see that my settings have been removed nor has the hanging problem gone away.  Please understand, it can hang without running any SQL, I can be just looking at the screen and when I attempt to scroll through a script it won't allow me to grab the scroll bar.

I also have an issue in which all of the Code Snippets are gone.  I am not sure if this related or not.

I have been living with the problem for several upgrades and am just to the point now where the hanging is seriously impacting my work.  Is there some process in TOAD which polls?  I know session browser does and I do not have than up.

Is there something else I can do return TOAD back to stop the hanging?  Maybe re-install?

Thanks,

David

Unanswered 87 5 / Create an account to join the discussion.
Ruben Soriano
Follow / 4 Aug 2017 at 10:26am / Toad for Oracle
Latest post by on 11 Aug 2017 at 12:30pm

Delay of about 3-4 seconds to appear popup 'find text' in...

Expand content
Good morning, I have Toad for Oracle Xpert v.9.5.0.31 running in Window 10 - 64 bits. When I'am coding in the editor, inside Toad, and I key 'Ctrl+F', the 'find text' popup has...

Good morning,

I have Toad for Oracle Xpert v.9.5.0.31 running in Window 10 - 64 bits.

When I'am coding in the editor, inside Toad, and I key 'Ctrl+F', the 'find text' popup has a delay of about 3 or 4 seconds to appear. This difficult enormously my coding tasks.

Somebody can help me please? Many thanks

81 1 / Create an account to join the discussion.
chazamania
Follow / 9 Aug 2017 at 8:47pm / Toad for Oracle
Latest post by on 10 Aug 2017 at 6:40pm

12.11 32bit "Invalid Path or SQL*Plus not found." error...

Expand content
Execute via SQL*plus isn't working on two separate 12.11 installs. My 12.10 "Executables" settings imported correctly and point to the correct executable. I live on this one simple feature...

Execute via SQL*plus isn't working on two separate 12.11 installs. My 12.10 "Executables" settings imported correctly and point to the correct executable. I live on this one simple feature. Help!

130 4 / Create an account to join the discussion.