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.

1621 1 / 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 4:01pm

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 299 21 / 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 44 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

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

275 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 66 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 59 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

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

75 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 79 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

77 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!

123 4 / Create an account to join the discussion.
Hans-Werner Schlote
Follow / 8 Aug 2017 at 7:45am / Toad for Oracle
Latest post by on 8 Aug 2017 at 2:00pm

12.11 drag from object palette vs 12.10

Expand content
Hi everybody, double-clicking a table in object palette inserts the table name to editor without schema in 12.10 and 12.11 - ok. Dragging a table to editor inserts the table name without schema in...

Hi everybody,

double-clicking a table in object palette inserts the table name to editor without schema in 12.10 and 12.11 - ok.

Dragging a table to editor inserts the table name without schema in 12. 10, table name with schema in 12.11 - different behaviour.

Why was this changed?

Regards and thx in advance

Answered 79 2 / Create an account to join the discussion.
ServiceAccount_Toad
Follow / 7 Aug 2017 at 8:48pm / Toad for Oracle
Latest post by on 8 Aug 2017 at 12:23pm

Facing issue connecting to Database with following Error

Expand content
OCI_INVALID_HANDLE, Can't initialize OCI. Error -1
OCI_INVALID_HANDLE, Can't initialize OCI. Error -1
Unanswered 82 1 / Create an account to join the discussion.
David U
Follow / 4 Aug 2017 at 8:17pm / Toad for Oracle
Latest post by on 7 Aug 2017 at 5:03pm

Code assist and parentheses matching issues

Expand content
Is anything being done to make code assist more reliable. It used to be great before v12.4 (or whenever Toad was rewritten), but now it frequently simply doesn't work. Also, will parentheses matching...
Is anything being done to make code assist more reliable.  It used to be great before v12.4 (or whenever Toad was rewritten), but now it frequently simply doesn't work.  
 
Also, will parentheses matching ever be restored to the way it worked prior to the rewrite?  Toad used to bold the inner pair of parentheses when the cursor was *anywhere* inside them.  Now, they are highlighted only when the cursor is next to one of them.
 
I'm using Toad for Oracle Xpert v12.11.0.95
 
Thanks.
Unanswered 73 1 / Create an account to join the discussion.
Christine
Follow / 3 Oct 2011 at 5:07pm / Toad for Oracle
Latest post by on 7 Aug 2017 at 3:49pm

formatting copy/paste query results

Expand content
Hi all, New to TOAD so I am having a few problems..... I can do the ctrl/insert to copy query results but the resulting data isn't under the header. Is there a way to copy/paste so you can see the...

Hi all,

New to TOAD so I am having a few problems.....

I can do the ctrl/insert to copy query results but the resulting data isn't under the header.  Is there a way to copy/paste so you can see the header and the data for that field under that header?

Thanks in advance for your help,
christine

14867 5 / Create an account to join the discussion.
kodiak_kid
Follow / 5 Aug 2017 at 10:27am / Toad for Oracle
Latest post by on 7 Aug 2017 at 3:03pm

Toad Script Runner results missing time

Expand content
Hi all, total newb here, but I did search and it looks like this format is correct. I get all of the data I need except for the time. I get the date, but I also need the time. Am I missing something...

Hi all,

total newb here, but I did search and it looks like this format is correct.  I get all of the data I need except for the time.  I get the date, but I also need the time.  Am I missing something here?  Thanks in advance!

SELECT TIME, batch_number, P17, P18

from lmes.V_BATCHENDDATA_12GD

where cell like '%12GD%' and P18 = 'Eval' and TIME between TO_DATE('07/18/2017 11:59:00 PM' , 'MM/DD/YYYY HH:MI:SS AM') and TO_DATE('08/01/2017 11:59:59 PM' , 'MM/DD/YYYY HH:MI:SS AM');

92 3 / Create an account to join the discussion.
Damir Vadas
Follow / 4 Aug 2017 at 10:00am / Toad for Oracle
Latest post by on 5 Aug 2017 at 6:34am

org. index table in table list grid showed as compressed

Expand content
Toad 12.12.0.6 For IOT table defined as (known hr schema): CREATE TABLE COUNTRIES ( COUNTRY_ID CHAR(2 CHAR) CONSTRAINT COUNTRY_ID_NN NOT NULL, COUNTRY_NAME VARCHAR2(40 CHAR), REGION_ID NUMBER, CONSTRAINT...

Toad 12.12.0.6

For IOT table defined as (known hr schema):

CREATE TABLE COUNTRIES
(
  COUNTRY_ID    CHAR(2 CHAR) CONSTRAINT COUNTRY_ID_NN NOT NULL,
  COUNTRY_NAME  VARCHAR2(40 CHAR),
  REGION_ID     NUMBER,
  CONSTRAINT COUNTRY_C_ID_PK
  PRIMARY KEY
  (COUNTRY_ID)
  ENABLE VALIDATE
)
ORGANIZATION INDEX
PCTTHRESHOLD 50
TABLESPACE ADBA_DATA
RESULT_CACHE (MODE DEFAULT)
NOPARALLEL
NOMONITORING
/

COMMENT ON COLUMN COUNTRIES.COUNTRY_ID IS 'Primary key of countries table.'
/

COMMENT ON COLUMN COUNTRIES.COUNTRY_NAME IS 'Country name'
/

COMMENT ON COLUMN COUNTRIES.REGION_ID IS 'Region ID for the country. Foreign key to region_id column in the departments table.'
/


-- Index COUNTRY_C_ID_PK is created automatically by Oracle with index organized table COUNTRIES.

--
-- Foreign Key Constraints for Table COUNTRIES
--
Prompt Foreign Key Constraints on Table COUNTRIES;
ALTER TABLE COUNTRIES ADD (
  CONSTRAINT COUNTR_REG_FK
  FOREIGN KEY (REGION_ID)
  REFERENCES REGIONS (REGION_ID)
  ENABLE VALIDATE)
/

Toad shows in tables list compression, which IMHO, should not be here.

Brg
Damir

90 2 / Create an account to join the discussion.
aaron.yao
Follow / 4 Aug 2017 at 3:53pm / Toad for Oracle
Latest post by on 4 Aug 2017 at 6:04pm

Scheduled Job failed

Expand content
My scheduled jobs kept failing since Toad upgrade, here is the error message -- Password not specified. Command line execution requires a saved password on the login screen, an overridden connection...
My scheduled jobs kept failing since Toad upgrade, here is the error message --

Password not specified. Command line execution requires a saved password on the login screen, an overridden connection using the -c command line option, or a parameter file.

Please help for this issue.

Thanks,
Aaron
Unanswered 91 1 / Create an account to join the discussion.
statey603
Follow / 4 Aug 2017 at 5:04pm / Toad for Oracle
Latest post by on 4 Aug 2017 at 5:55pm

Where did Syntax Highlighting setting go in Toad For Oracle v12.10...

Expand content
I recently upgraded from 12.5 to 12.10. I imported my 12.5 settings, however, the Auto-Uppercase behavior while typing keywords in the editor is no longer working. I checked and under View - Options...

I recently upgraded from 12.5 to 12.10.

I imported my 12.5 settings, however, the Auto-Uppercase behavior while typing keywords in the editor is no longer working.

I checked and under View - Options, there no longer is a Syntax Highlighting selection under Editor - Behavior settings.

Does anyone know where the Syntax Highlighting settings are?

Thanks

70 2 / Create an account to join the discussion.