You will no longer receive e-mail notifications from this forum.
Log-In to post
Contact Support on Twitter
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:
- Link to Download & Documentation:
- Link to Trial:
- Overview of new feature(s) (with link to the 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
Feel free to browse them. Remember to sign in to your account to view.
Im currently running "Toad For Oracle Xpert x64 Version 184.108.40.206" 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?
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.
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
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.
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?
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 )
(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) );
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
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 8/11/2017 1. Created this trigger.
Automatically available Auto Replace Keywords:
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)
tmpVar := 0;
SELECT MySeq.NEXTVAL INTO tmpVar FROM dual;
:NEW.SequenceColumn := tmpVar;
:NEW.CreatedDate := SYSDATE;
:NEW.CreatedUser := USER;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
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?
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.
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?
I have Toad for Oracle Xpert v.220.127.116.11 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
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!
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
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
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
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');
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 INDEXPCTTHRESHOLD 50TABLESPACE ADBA_DATARESULT_CACHE (MODE DEFAULT)NOPARALLELNOMONITORING/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.
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?