You will no longer receive e-mail notifications from this forum.
Log-In to post
Tomorrow, we are kicking off a new daily content feature in Social Media.
We can show your Social Media presence with other Toad users tomorrow using the hashtag, #ToadTuesday
This is the tweet that will start the hashtag trending:
Hashtag game! Tweet out how long Toad has been a part of your life! Tag w/ #ToadTuesday.
You could be featured on next blog!
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
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.
Using TOAD for Oracle, version 22.214.171.124. When I encounter a PL/SQL error, which sadly is very often as I'm a newbie when it comes to PL/SQL, the line number in the Oracle error message is not correct if my code contains comments and/or blank lines. Is there any way to get the true and correct line number to display? For example, the attached image shows a slightly modified version of code provided by Tom Kyte for searching all columns in all tables. For anyone interested, I am running a modified version of code available at this URL: asktom.oracle.com/.../f
I am only allowed to run this code in anonymous mode, as the DBA will not create a saved procedure. I have added extensive commenting that is shown on the first (32) lines. As you can see, the error number indicates a line (line 42) that could not possibly have attracted the error in question, since this is still part of the Declare section:
This one is specific to this search procedure. I have copied the procedure below, sans a few comments internal to the company I work for, that I cannot share. My question relates to the third comment. I have found that if two columns in the same table include the search term (same data), only the first column found will be displayed in the output. I know it is not good database design to have data repeated in two columns, but it is what it is....I have no control of the existing design.
/* Adaptation of Tom Kyte procedure to search all tables in an Oracle database for a particular data value. This adaptation allows the procedure to run in anonymous mode, which means that you do not need to create the procedure first. Reference:asktom.oracle.com/.../f Note: Had to use the ALL_TAB_COLUMNS table, instead of the USER_TAB_COLUMNS table. Included a criteria for OWNER that is not found in the original procedure.
CAUTIONS: 1.) MUST use the "Execute as script" button. MUST select the correct schema, in TOAD's "Current Schema" drop-down, to run as that user. If changing the schema, note that there are two places where the schema is specified in the code.
2.) 4 line comment removed
3.) This procedure seems to stop searching a table after it finds a hit. If the searched string is included in a different column in the same table, it appears as if the procedure does not findthe data.
set serveroutput on size unlimited
declare i_count number:=0; l_cols long; l_where long; l_cursor sys_refcursor; l_cname varchar2(4000); p_string varchar2(4000):='C93A'; begin dbms_application_info.set_client_info( '%' || p_string || '%' ); dbms_output.put_line('Data Searched: ' || p_string); dbms_output.put_line(' ');
for x in ( select table_name from all_tables where owner = 'APDBMS_SOR' order by table_name ) -- <-- Added by Tom, so that results will print alphabetically, by table_name -- for x in ( select table_name from user_tables ) loop l_cols := 'case when 1=0 then ''x'' '; l_where := ' where ( 1=0 '; for y in ( select '"' || column_name || '"' column_name from all_tab_columns-- from user_tab_columns where table_name = upper(x.table_name) and owner = 'APDBMS_SOR' and (data_type in ( 'CHAR', 'NVARCHAR2', 'VARCHAR2' )) --and (data_type in ( 'CHAR', 'DATE', 'FLOAT', 'NCHAR', 'NUMBER', 'NVARCHAR2', 'VARCHAR2' ) --or data_type like 'INTERVAL%' or data_type like 'TIMESTAMP%' ) -- order by column_name -- <-- Added by Tom, so that results will print alphabetically, by table_name, but it turns out the procedure finds only the first column in a table. ) loop l_cols := l_cols || ' when ' || y.column_name || ' like sys_context(''userenv'',''client_info'') then ' || ' ''' || y.column_name || ''''; l_where := l_where || ' or ' || y.column_name || ' like sys_context(''userenv'',''client_info'') '; end loop; open l_cursor for 'select ' || l_cols || 'else null end cname from ' || x.table_name || l_where || ') and rownum=1'; fetch l_cursor into l_cname; if ( l_cursor%found ) then i_count:=i_count + 1; -- Why can't I increment a counter variable without attracting error: PLS-00306: wrong number or types of arguments in call to '+' -- Answer: i_count was declared as long. When I changed it to number, the code runs, however, it appears to be null below dbms_output.put_line(x.table_name || chr(9) || chr(9) || l_cname ); --dbms_output.put_line('-- ' || x.table_name || chr(9) || chr(9) || l_cname ); dbms_output.put_line('select * from ' || x.table_name || ' where ' || l_cname || ' like ''%' || p_string || '%'';'); dbms_output.put_line(' '); end if; close l_cursor; end loop; dbms_output.put_line(' '); -- Added to provide a single line in-between our results and the summary that starts with " PL/SQL procedure successfully completed." dbms_output.put_line(i_count || ' tables found.'); -- <-- Result is " tables found." without any number indicated?? -- Solution: Initialized variable to zero in declaration, e.g. Changed: "i_count number;" to: "i_count number:=0;" dbms_output.put_line(' ');end;/
I am watching the following video: https://www.quest.com/video/create-a-simple-plsql-unit-test-using-toad8121749/ but when I come to display the "PL/SQL Results" tab in order to create the unit test, I don't have that option in the tab menu. I'm using 12.6.0 Professional edition, I'm assuming that something isn't configured at a DBA level, but not sure what??
I'm don't have DBA access, but can ask our DBA
I been searching everywhere but cant find a trial version of Toad for Oracle Base Edition to download. We currently running SQL Developer and would like to test the Base Edition, we are not Oracle DBA's that needs all the fancy stuff TOAD offers but rather software developers that would like to execute queries and run SQL optimizations.
Thanks in advance
I have a question about Formatting Options in TOAD 126.96.36.199.
Is the a way to put parameter declarations in columns. The only 3 options either line up IN with IN and OUT with OUT or compact everything to the left. Below is what I am interested in seeing if its possible.
IN OUT IN OUT
I am using TOAD 12.6. The database is installed locally. So I have access to both SYSTEM and the sample HR schema in Oracle.
I have searched some posts about how to enable Debug in TOAD with no avail. I have already got DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE grants for the HR user in the schema. However, in the TOAD session, the Session > "Toggle Compiling with Debug is still greyed out for the HR session.
The 'Toggle Compiling with debug' option is enabled in the SYSTEM user, but greyed out in the HR user. Please advise, what else do I need to perform to make it work in HR schema.
Apparently when I was last in Toad for Oracle, I changed the location of this file (Application Data Directory) to a directory within which I do not have full read/write.. inadvertently.
Now Toad will not start, stating it cannot read this file. Is there a key value for this setting within the registry? I find TOAD under current_user > software > Dell, but the only keys listed here are for Edition, License, Package Product and Version...
I searched for appdata without finding the location, and searched for the first portion of the directory location without finding any mention in the registry.
Can you tell me where within the registry it would be located ?
Or should I uninstall and re-install Toad for Oracle? Or is there an alternative solution? Toad version 12.10.
The error message on starting toad reads:
"Toad cannot update its client files. Please make sure you have full read and write access to Directory to which I changed the location...
Details: Cannot copy file "SDFConverter.exe to Directory...."
Thank you for any help...
when using Toad to convert a query featuring outer joins written in the old Oracle notation into ANSI notation, I've run into a problem:
If I write it like this:
select AGENTS.AG_AGCLE, AGENTS.AG_NOM, S01_SERVICES.SE_CODE, S01_DEPART.DP_CODE, S01_DEPART.DP_NOM, CONGES.CG_CPANT, S01_PERSO.PE_TEMPSW, MEDWORK.MK_VILLE, MEDWORK.MK_DOCTORNAME from S01_PERSO,S01_SERVICES,S01_DEPART,AGENTS,CONGES,MEDWORK where SE_DPCLE=DP_DPCLE and SE_SECLE=PE_SECLE and PE_AGCLE=AG_AGCLE and AG_AGCLE=CG_AGCLE(+) and AG_MKCLE=MK_MKCLE(+)and PE_PECLE=25;
Toad converts it to this, which is correct:
SELECT AG_AGCLE, AG_NOM, SE_CODE, DP_CODE, DP_NOM, CG_CPANT, PE_TEMPSW, MK_VILLE, MK_DOCTORNAME
INNER JOIN AGENTS ON (PE_AGCLE = AG_AGCLE)INNER JOIN S01_SERVICES ON (SE_SECLE = PE_SECLE)INNER JOIN S01_DEPART ON (SE_DPCLE = DP_DPCLE)LEFT OUTER JOIN CONGES ON (AG_AGCLE = CG_AGCLE)LEFT OUTER JOIN MEDWORK ON (AG_MKCLE = MK_MKCLE)WHERE PE_PECLE = 25;
Whereas if I write it like this, which is the same query (I just wrote one of the join conditions the other way round):
select AGENTS.AG_AGCLE, AGENTS.AG_NOM, S01_SERVICES.SE_CODE, S01_DEPART.DP_CODE, S01_DEPART.DP_NOM, CONGES.CG_CPANT, S01_PERSO.PE_TEMPSW, MEDWORK.MK_VILLE, MEDWORK.MK_DOCTORNAME from S01_PERSO,S01_SERVICES,S01_DEPART,AGENTS,CONGES,MEDWORK where SE_DPCLE=DP_DPCLE and SE_SECLE=PE_SECLE and PE_AGCLE=AG_AGCLE and CG_AGCLE(+)=AG_AGCLEand AG_MKCLE=MK_MKCLE(+)and PE_PECLE=25;
Toad converts it to this, which is wrong!
SELECT AG_AGCLE, AG_NOM, SE_CODE, DP_CODE, DP_NOM, CG_CPANT, PE_TEMPSW, MK_VILLE, MK_DOCTORNAMEFROM S01_PERSOINNER JOIN AGENTS ON (PE_AGCLE = AG_AGCLE)INNER JOIN S01_SERVICES ON (SE_SECLE = PE_SECLE)INNER JOIN S01_DEPART ON (SE_DPCLE = DP_DPCLE)LEFT OUTER JOIN MEDWORK ON (AG_MKCLE = MK_MKCLE)RIGHT OUTER JOIN CONGES ON (CG_AGCLE = AG_AGCLE)WHERE PE_PECLE = 25;
I have searched online for this problem and found nothing, Has anybody else come across this? Is this a bug, or am I missing something? If it is a bug, how come a product as mature as Toad can still have bugs this serious?
I'm using Toad for Oracle Freeware 188.8.131.52, 64 bit on Windows 7 64 bit.
Thanks in advance.
Toad for Oracle
Toad for oracle Xpert(64-bit),Add-Ons: DB Admin Module.
Version : 184.108.40.206
Have been facing issue with total lately with export data/create script/create in another schema/import fields option.
after selecting all the options in the wizard and clicking "OK" it runs into "Access voilation at address.." error.
Previously these errors used to go away - after restarting Toad.
Most recent error :
"Access violation at address 000000000482D230 in module 'Toad.exe'. Read of address 000000000000011D"
Has anyone else come across any such issue?
Got a new laptop and TOAD is now exporting double number formats as short text.Old computer kept double number data type but new computer overwrites to new tables when exporting as Short Text format.For example, our customer id numbers are 10 digit numeric (double, not long integer). When exported to MS Access, the data type is Short Text.Old computer was Windows 7 and Toad for Oracle 10.6.1.3.New computer is Windows 10 and Toad for Oracle 220.127.116.11I dread having to convert all my files impacted. Is there a Toad Option to keep numbers as numbers when exporting?
Sometimes I mouse over and hit something in the Data Grid that causes the row height to grow. Used to be in an older version of TOAD, there was a right-click on the left side of the grid for adjusting the row height so that I can put it back to normal. I surely cannot find that now. Does anyone know?
I am using TOAD for Oracle, version 18.104.22.168. When I am using the Editor (Database > Editor), with the Object Palette displayed, I like to double-click column names to add them to a query I am creating. However, when I do this, the column names are added without commas. For example, I get this:
select currentstatus program last_modified_by....
instead of this:
select currentstatus, program, last_modified_by....
I find that I have to manually insert the commas, which is silly. There must be a better way.
Note: If I use the <Ctrl> key to select more than 1 column, and then drag to the Editor window, commas *are* inserted, as expected. It is just when double-clicking column names one-at-a-time that I get the spaces without a comma.
I have observed that for few schemas, the data fetch limit is 500 rows and for few schemas its 300.I am in Toad version 22.214.171.124. I could not find parameters "Limit Grid Fetch" or "OCI Buffer Size".Could you please help to understand where these parameters are defined and how they are differing at schema level?
After launching Toad the first logon to the database I get a pop up with the above message. Message disappears on clicking OK and subsequent logon in the same session doesn't display the error message again. Message only pop ups after launching a new instance of Toad and attempting to logon. I use 32bit 126.96.36.199 and use Oracle 32bit client 12.1.0 on windows 7 64bit. How do you get rid of this annoying error message which doesn't seem like a real error since it just goes away without any loss of functionality.
I need to setup Toad to use Kerberos. I have installed Kerberos and can connect to an Oracle database using SQLPlus /@dbname . However, when I try to connect to the same database from Toad using blank username/password or EXTERNAL and blank password, TOAD throws ORA-12641: Authentication service failed to initialize error. I have searched the forums and Internet for answers. I cannot use OPS$. Any suggestions?