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.
How do I choose the data type I want when importing a txt file or excel file?
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.
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...
TOAD 126.96.36.199 ~ Oracle 188.8.131.52.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.
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.
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 :
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 vwhere 1=1and 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?
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!