Danny Torres
Follow / 14 Sep 2016 at 5:03pm / Toad for Oracle
Latest post by on 28 Nov 2017 at 6:27pm

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 Quest Support

This opens the "Email Quest Support" window with instructions and links to contact Support, and to open a new case or service request.

Quest Web Support

This opens Quest 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. 

Release Information: 

Here are some key links: 

  • Link to Documentation:

https://support.quest.com/toad-for-oracle        

(Release Notes includes latest release enhancements; Installation Guide includes pre-requisites; Getting Started includes product features) 

  • Link to Downloads (existing customers):

https://support.quest.com/toad-for-oracle/download-new-releases 

  • Link to Trial (new customers):

https://www.quest.com/products/toad-for-oracle/software-downloads.aspx

  • Knowledge Base Articles:

https://support.quest.com/toad-for-oracle/kb 

The Support Knowledge Base includes Videos, Tutorials, and other information intended to help users.

Feel free to browse the knowledge base articles. Remember to sign in to your account to view.

2857 3 / Create an account to join the discussion.
an1518
Follow / 20 Jan 2018 at 1:47am / Toad for Oracle

TOAD Space Manager

Expand content
Hi, Toad Space manager is creating a user named TOAD and tables to support the history of the DB growth. Is there a way for the process to not create a new user named TOAD? We are not allowed to create...

Hi,

Toad Space manager is creating a user named TOAD and tables to support the history of the DB growth. Is there a way for the process to not create a new user named TOAD? We are not allowed to create new users but I would like to use the tool.

Unanswered 24 0 / Create an account to join the discussion.
Vliegezwam
Follow / 20 Jun 2012 at 5:22pm / Toad for Oracle
Latest post by on 19 Jan 2018 at 5:33pm

Toad Automation Designer - Set Variable action - cannot use expre...

Expand content
Hi all, In a Set Variable action, I cannot seem to use an expression as 'value'. In Toad for Data Analysts, you can use e.g. SELECT TO_CHAR(SYSDATE-1,'DDMMYY') FROM DUAL and get the result...

Hi all,

In a Set Variable action, I cannot seem to use an expression as 'value'. In Toad for Data Analysts, you can use e.g.
          SELECT TO_CHAR(SYSDATE-1,'DDMMYY') FROM DUAL
 and get the result of the expression into the value in a Set_Variable activity.

However, if you do that in Toad Automation Designer, the value becomes the select statement as a string. Reducing it just to the TO_CHAR() bit has a similar effect. I can't get the result from the expression into the variable value. I can use a single system variable (e.g. %SYSDATE%), but other expressions don't seem to work. Any thoughts?

11945 3 / Create an account to join the discussion.
Mara_B
Follow / 17 Jan 2018 at 8:49pm / Toad for Oracle
Latest post by on 19 Jan 2018 at 5:25pm

How do I get multiple data records from a query using variables

Expand content
I am new to TOAD and Oracle. This is SQL code, How do I do this in TOAD to get the result set and without the popup window which ask for a value input. This process will run daily to extract data, so flexibility...

I am new to TOAD and  Oracle.   This is SQL code, How do I do this in TOAD to get  the result set and without the popup window which ask for a value input.  This process will run daily to extract data, so flexibility is needed with the dates. 

DECLARE @tempdate datetime

 

SET @tempdate = (SELECT case when DATEPART(dw,GETDATE()) = 2 then dateadd(dd,-3,getdate() )

                           else dateadd(dd,-1,getdate() )

                           End

                    )

 

Select * from ABC.TRAN where ENTRYDATE = @tempdate

158 4 / Create an account to join the discussion.
jennifer_22301
Follow / 18 Jan 2018 at 6:13pm / Toad for Oracle
Latest post by on 19 Jan 2018 at 5:22pm

View Script Formatting - Toad for Oracle 12.11.0.95

Expand content
Have searched for answers on this forum, unable to find the specific answer. Apologies if I missed it. Issue: Using the Describe Objects feature (clicking F4 on view name) and Script (with Views >...

Have searched for answers on this forum, unable to find the specific answer.  Apologies if I missed it.

Issue: Using the Describe Objects feature (clicking F4 on view name) and Script (with Views > Format UNCHECKED), results in:

Create or replace view X_view 

(column_1,column_2,column_3)

as

select

          -- header comment1

          -- header comment2

  x1 column_1,

  x1 column_2,

  x1 column_3

from table;

What I need: 

Create or replace view X_view 

(column_1,

 column_2,

 column_3)

as

        select

                   -- header comment1

                   -- header comment2

  x1 column_1,

  x1 column_2,

  x1 column_3

from table;

If Format is CHECKED then the column names are aligned as desired, but the content of the select statement are skewed all over the place (i.e., the comments, and many of the lines are split into separate lines).

Create or replace view X_view 

(column_1,

 column_2,

 column_3)

as

       select

                                                                                                                               -- header comment1

                                                                                                         -- header comment2

  x1

               column_1,

  x1

               column_2,

  x1

               column_3

from table;

In Toad for Oracle 12.10.0.30, I was able to leave the Format option CHECKED, and the format came out formatted like this:

Create or replace view X_view 

(column_1,

 column_2,

 column_3)

as

        select

                   -- header comment1

                   -- header comment2

  x1 column_1,

  x1 column_2,

  x1 column_3

from table;

Any hints are appreciated.  It is very difficult to read the views in my current Toad version. :(  

106 2 / Create an account to join the discussion.
HHPete
Follow / 17 Jan 2018 at 2:16pm / Toad for Oracle
Latest post by on 17 Jan 2018 at 6:49pm

Automation - script to update user variable

Expand content
I'm new to this forum and only somewhat familiar with some of the TOAD features. IE Toad Newbie and SQL Newbie. I am using Toad for Oracle 12.12.0.39 and am stuck with the if...then...else syntax...

I'm new to this forum and only somewhat familiar with some of the TOAD features.  IE Toad Newbie and SQL Newbie.

I am using Toad for Oracle 12.12.0.39 and am stuck with the if...then...else syntax.

I have already created a User Variable in the script and started with a default value.  Now I want to change the value associated with that user variable based on the result of a query (or some other logical option)

Options such as

  • Table exists
  • Rows returned from a query > 0
  • Query result (single row, single column output)

Would appreciate some insight.  I really like the automation designer but the folks I work with do not use it, so they can't really answer my questions.

thanks in advance

P

144 4 / Create an account to join the discussion.
B.Cernik
Follow / 17 Jan 2018 at 12:40pm / Toad for Oracle
Latest post by on 17 Jan 2018 at 2:14pm

Templates for multiple schema compare.

Expand content
Hello Is it possible folowing funkcionality in the new versions of the Toad for Oracle? Create and manage more templates for multiple schema compare. When I am connected to DB instance and I start...

Hello

Is it possible folowing funkcionality in the new versions of the Toad for Oracle?

Create and manage more templates for multiple schema compare.
When I am connected to DB instance and I start multiple schema compare I'd like to select template compare setting from the list of previous saved compares.
Now I must create setting every one compare. Default settings in the current wizzard is not set as I want now.
In the 90% of the use there are 2-3 types of compare settings and 6 different target/source (instance/schema).

In the second.

Is it possible to add there own items of source to compare?
Add interface how to get list of  user defined source types for compare from the DB and user defined items with unique code of the object and text source of the object.

Best regards

Betislav Cernik

95 1 / Create an account to join the discussion.
KishanMashru
Follow / 17 Jan 2018 at 8:57am / Toad for Oracle
Latest post by on 17 Jan 2018 at 2:05pm

Toad For Oracle : base Edition Installation Error System.DllNotFoundException...

Expand content
I am trying to Install Toad For Oracle 2017R2 Edition Installer(X86) and am getting the below mentioned error as soon as I click Next on the main screen. I am having full access the required path (C...

I am trying to Install Toad For Oracle 2017R2 Edition Installer(X86) and am getting the below mentioned error as soon as I click Next on the main screen.

I am having full access the required path (C:\Users\mashrkp\AppData\Local\Temp\tmp5A10.tmp) and can see various .txt files created by TOAD.

Can anyone help me with this?

Thanks in advance!!!

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.DllNotFoundException: Unable to load DLL 'C:\Users\mashrkp\AppData\Local\Temp\tmp5A10.tmp': Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at Quest.Licensing.Validation.TempWrapper.getCurrentDay()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Quest.Licensing.Validation.ClassWrapper.GetCurrentDay()
at Quest.Licensing.QuestKeyFactory.QKFInitialize()
at Quest.Licensing.QuestKeyFactory..ctor()
at Installer.BLL.Business.GetValidLicenses()
at Installer.UIL.ProductLicensing..ctor(Business BusinessObject)
at Installer.BLL.Business.UpdatePanel()
at Installer.BLL.Business.DoNext()
at Installer.UIL.MainForm.btnNext_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
BootstrapperCore
Assembly Version: 3.0.0.0
Win32 Version: 3.10.0.2103
CodeBase: file:///C:/Users/mashrkp/AppData/Local/Temp/%7B70136b78-8dcc-435f-9787-ef0cd5e5cdc1%7D/.ba1/BootstrapperCore.DLL
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36391 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Installer
Assembly Version: 1.0.6490.39345
Win32 Version: 1.0.6490.39345
CodeBase: file:///C:/Users/mashrkp/AppData/Local/Temp/%7B70136b78-8dcc-435f-9787-ef0cd5e5cdc1%7D/.ba1/Installer.DLL
----------------------------------------
Quest.SecTech
Assembly Version: 4.5.1.490
Win32 Version: 4.5.1.490
CodeBase: file:///C:/Users/mashrkp/AppData/Local/Temp/%7B70136b78-8dcc-435f-9787-ef0cd5e5cdc1%7D/.ba1/Quest.SecTech.DLL
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.Deployment.WindowsInstaller
Assembly Version: 3.0.0.0
Win32 Version: 3.10.0.2103
CodeBase: file:///C:/Users/mashrkp/AppData/Local/Temp/%7B70136b78-8dcc-435f-9787-ef0cd5e5cdc1%7D/.ba1/Microsoft.Deployment.WindowsInstaller.DLL
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36391 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

111 1 / Create an account to join the discussion.
Brad Boddicker
Follow / 17 Jan 2018 at 2:02pm / Toad for Oracle

RE: [Toad for Oracle - Discussion Forum] Toad For Oracle : base Edition...

Expand content
Hello, It sounds like the "Bundle" is the issue here, the GUI interface that holds the MSI files. Please try running the MSI files directly, located here: support.quest.com/.../download...
Hello,
 
It sounds like the "Bundle" is the issue here, the GUI interface that holds the MSI files.  Please try running the MSI files directly, located here:  support.quest.com/.../download-new-releases 
 
 
From: KishanMashru [mailto:bounce-KishanMashru@toadworld.com]
Sent: Wednesday, January 17, 2018 8:24 AM
To: toadoracle@toadworld.com
Subject: [Toad for Oracle - Discussion Forum] Toad For Oracle : base Edition Installation Error System.DllNotFoundException: Unable to load DLL 'C:\Users\mashrkp\AppData\Local\Temp\tmp5A10.tmp': Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDEN...
 
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
 
Thread created by KishanMashru

I am trying to Install Toad For Oracle 2017R2 Edition Installer(X86) and am getting the below mentioned error as soon as I click Next on the main screen.

I am having full access the required path (C:\Users\mashrkp\AppData\Local\Temp\tmp5A10.tmp) and can see various .txt files created by TOAD.

Can anyone help me with this?

Thanks in advance!!!

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.DllNotFoundException: Unable to load DLL 'C:\Users\mashrkp\AppData\Local\Temp\tmp5A10.tmp': Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at Quest.Licensing.Validation.TempWrapper.getCurrentDay()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Quest.Licensing.Validation.ClassWrapper.GetCurrentDay()
at Quest.Licensing.QuestKeyFactory.QKFInitialize()
at Quest.Licensing.QuestKeyFactory..ctor()
at Installer.BLL.Business.GetValidLicenses()
at Installer.UIL.ProductLicensing..ctor(Business BusinessObject)
at Installer.BLL.Business.UpdatePanel()
at Installer.BLL.Business.DoNext()
at Installer.UIL.MainForm.btnNext_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
BootstrapperCore
Assembly Version: 3.0.0.0
Win32 Version: 3.10.0.2103
CodeBase: file:///C:/Users/mashrkp/AppData/Local/Temp/%7B70136b78-8dcc-435f-9787-ef0cd5e5cdc1%7D/.ba1/BootstrapperCore.DLL
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36391 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Installer
Assembly Version: 1.0.6490.39345
Win32 Version: 1.0.6490.39345
CodeBase: file:///C:/Users/mashrkp/AppData/Local/Temp/%7B70136b78-8dcc-435f-9787-ef0cd5e5cdc1%7D/.ba1/Installer.DLL
----------------------------------------
Quest.SecTech
Assembly Version: 4.5.1.490
Win32 Version: 4.5.1.490
CodeBase: file:///C:/Users/mashrkp/AppData/Local/Temp/%7B70136b78-8dcc-435f-9787-ef0cd5e5cdc1%7D/.ba1/Quest.SecTech.DLL
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.Deployment.WindowsInstaller
Assembly Version: 3.0.0.0
Win32 Version: 3.10.0.2103
CodeBase: file:///C:/Users/mashrkp/AppData/Local/Temp/%7B70136b78-8dcc-435f-9787-ef0cd5e5cdc1%7D/.ba1/Microsoft.Deployment.WindowsInstaller.DLL
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36391 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
Microsoft.GeneratedCode
Assembly Version: 1.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.36388 built by: FX452RTMLDR
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

41 0 / Create an account to join the discussion.
leszek.beszterda
Follow / 12 Oct 2015 at 3:47pm / Toad for Oracle
Latest post by on 17 Jan 2018 at 2:00pm

Batch to export SQL script output to excelt flat file

Expand content
Hi dear member, Does it possible to create a windows command to export data set of SQL query to Excell file in Toad for Oracle 12.7.1.11 Basi Edition? Kind regards Leszek B.
Hi dear member,

Does it possible to create a windows command to export data set of SQL query to Excell file in Toad for Oracle 12.7.1.11 Basi Edition?

Kind regards
Leszek B.
Answered 4164 4 / Create an account to join the discussion.
mesailor
Follow / 15 Jan 2018 at 2:29am / Toad for Oracle
Latest post by on 16 Jan 2018 at 6:40pm

Toad for Oracle 12.12.0.39; Copy table with clob from one database...

Expand content
Trying to move multiple tables from one database to another. Tables with a CLOB element fail and I get "List Index Our of Bounds (?)" where the ? is column index of the first CLOB datatype. This...

Trying to move multiple tables from one database to another.  Tables with a CLOB element fail and I get  "List Index Our of Bounds (?)" where the ? is column index of the first CLOB datatype.  This is very consistent.

Is there something I need to set to ensure clobs are supported?  Having no issues with the 90%+ of my tables that do not have clobs.

Thanks

Dwain

217 8 / Create an account to join the discussion.
SGreenwood
Follow / 15 Jan 2018 at 11:24pm / Toad for Oracle
Latest post by on 15 Jan 2018 at 11:33pm

RE: [Toad for Oracle - Discussion Forum] Toad 11 will not startup

Expand content
Mike, Thank you for the information. My company sends out automatic patches/updates, and we have no way to turn off their installation, so I wouldn't be surprised if that's part of...
Mike,
 
  Thank you for the information.
 
  My company sends out automatic patches/updates, and we have no way to turn off their installation, so I wouldn't be surprised if that's part of the issue.  I've fired off an email to other folks that I work with to see if they are recently seeing a similar issue.
 
  I realized that Toad does actually start up, but it is REALLY slow.  It takes about 45 minutes for the splash screen to appear, saying "checking for critical files".  Then, it does finally start up after about 2 hours.
 
  Please let me know if there is any way I can see what is actually going on (via a log file).  Perhaps I could figure out some way around this.  Otherwise, I'm going to have to deal with Oracle's SQL Developer.
 
Thanks again,
Steve

---------- Original Message ----------
From: Gregory Liss <bounce-GTDG@toadworld.com>
To: <toadoracle@toadworld.com>
Subject: RE: [Toad for Oracle - Discussion Forum] Toad 11 will not startup
Date: Mon, 15 Jan 2018 08:25:39 -0800

Reply by Gregory Liss

Did your company recently implement any additional security applications/filters?  McAfee has been known to cause Toad to have issues in the past and needs to be "whitelisted" for some firewall/malware tools.

 
To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.



____________________________________________________________
We Say GoodBye To Sally Fields
iflperfecttouch.com
http://thirdpartyoffers.juno.com/TGL3132/5a5d37d63b15537d6123est03vuc
SponsoredBy Content.Ad
119 1 / Create an account to join the discussion.
SGreenwood
Follow / 15 Jan 2018 at 4:19pm / Toad for Oracle
Latest post by on 15 Jan 2018 at 4:24pm

Toad 11 will not startup

Expand content
Hello, I have been using Toad 11 on my computer for years, but all of the sudden I cannot get it to startup. It shows that it is running in the Task Manager (with minimal memory being used), but I...

Hello,

  I have been using Toad 11 on my computer for years, but all of the sudden I cannot get it to startup.  It shows that it is running in the Task Manager (with minimal memory being used), but I never even see the Toad splash screen (or hear its accompanying "croak").

  I am using a Windows 7 Enterprise laptop (x64).

  Toad is installed in C:\Quest\Toad for Oracle 11.

  My Oracle client is installed in C:\oracle\product\11.2.0.

  I have removed and reinstalled Toad multiple times to try to correct the issue.  I have also restarted my laptop multiple times, with no luck.

  I also have removed the C:\Users\...\AppData\Roaming\Quest Software directory, as suggested in another post.

Do you have any recommendations, or could you tell me where I could find the logs so that I could attempt to troubleshoot this further?

Thank you.

174 1 / Create an account to join the discussion.
Dave
Follow / 23 Dec 2017 at 9:24pm / Toad for Oracle
Latest post by on 11 Jan 2018 at 4:29pm

Schema Browser: Why do Materialized Views show INVALID when in Mat...

Expand content
Why do materialized views show a red X (invalid) in Mat. View mode (only) on the left and as INVALID when referenced in the Used By tab on the right? Both the Object and Accessing views appear perfectly...

Why do materialized views show a red X (invalid) in Mat. View mode (only) on the left and as INVALID when referenced in the Used By tab on the right?  Both the Object and  Accessing views appear perfectly fine and return the data correctly.  This seems fairly consistent and is not resolved with nightly refreshes.  I'm getting to the point where I think this is safe to ignore, but I thought I'd ask before I officially Don't Care.  Thanks for any wisdom ...  (and Happy Holidays.)

Dave

Unanswered 575 12 / Create an account to join the discussion.
Jorley
Follow / 4 Oct 2017 at 4:08pm / Toad for Oracle
Latest post by on 11 Jan 2018 at 2:19pm

Comparing procedures with case sensitive option on results in "No...

Expand content
We are working with multiple users on the same procedures and some of us have different toad settings/formatting. Whenever we compare we like to see what the changes are with our production server. ...

We are working with multiple users on the same procedures and some of us have different toad settings/formatting.

Whenever we compare we like to see what the changes are with our production server.

In comparing with the case sensitive option on it gives some procedures that are different, but when trying to see the differences, Toad gives the message "No more differences" found.

How can I make sure that Toad shows me differences?

Answered 1667 20 / Create an account to join the discussion.
sachin88narkhede
Follow / 10 Jan 2018 at 7:11pm / Toad for Oracle
Latest post by on 10 Jan 2018 at 7:27pm

sqlnet editor red x

Expand content
Hi, I am not able to connect to any database, but my colleague are able to connect using Toad. I am planning to buy Toad software so before that I am using trail version in order to check if I have...

Hi,

I am not able to connect to any database, but my colleague are able to connect using Toad.

I am planning to buy Toad software so before that I am using trail version in order to check if I have any software issue.

Please help

Thanks,
Sachin

189 1 / Create an account to join the discussion.
jimener
Follow / 10 Jan 2018 at 5:25pm / Toad for Oracle
Latest post by on 10 Jan 2018 at 5:30pm

[Error] Explain Plan (20: 8): ORA-02019: connection description for...

Expand content
I the this error when I select the explain plan button in toad [Error] Explain Plan (20: 8): ORA-02019: connection description for remote database not found

I the this error when I select the explain plan button in toad

[Error] Explain Plan (20: 8): ORA-02019: connection description for remote database not found

189 1 / Create an account to join the discussion.
mattbyrne
Follow / 5 Jan 2018 at 2:58pm / Toad for Oracle
Latest post by on 10 Jan 2018 at 1:09pm

Code Analysis option not appearing

Expand content
I am currently using Toad for Oracle V 12.11.0.95. I do not see a Code Analysis under Database>Diagnose or under View>Toad options When I tried to use the hotkey ctrl+F9 I receive the following...

I am currently using Toad for Oracle V 12.11.0.95.  I do not see a Code Analysis under Database>Diagnose or under View>Toad options

When I tried to use the hotkey ctrl+F9 I receive the following error. 

ORA-00942: table or view does not exist

Anyone know how I can enable this option?

Thank you Matt

262 2 / Create an account to join the discussion.
David Woed
Follow / 8 Jan 2018 at 7:22pm / Toad for Oracle
Latest post by on 10 Jan 2018 at 9:38am

My Toad failed to save my passwords.

Expand content
I restart my computer and when I started up toad again I don't know what the message said but when in the connection screen, everything that was saved was now gone and lost my save login details, anyone...

I restart my computer and when I started up toad again I don't know what the message said but when in the connection screen, everything that was saved was now gone and lost my save login details, anyone know what happened?

Unanswered 228 1 / Create an account to join the discussion.
knareshseo92
Follow / 10 Jan 2018 at 8:29am / Toad for Oracle

APEX to upload a text file and write into a table

Expand content
One of the web development projects using Oracle APEX I’m working on is to upload the content of a text file in csv format into database. By default, all files using the “File Browse..”...

One of the web development projects using Oracle APEX I’m working on is to upload the content of a text file in csv format into database. By default, all files using the “File Browse..” element will be uploaded to the “wwv_flow_files” table which has structure as follows:

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
SQL> desc wwv_flow_files
Name         Type           Nullable Default Comments
------------ -------------- -------- ------- --------
ID           NUMBER
FLOW_ID      NUMBER
NAME         VARCHAR2(90)
FILENAME     VARCHAR2(400)  Y
TITLE        VARCHAR2(255)  Y
MIME_TYPE    VARCHAR2(48)   Y
DOC_SIZE     NUMBER         Y
DAD_CHARSET  VARCHAR2(128)  Y
CREATED_BY   VARCHAR2(255)  Y
CREATED_ON   DATE           Y
UPDATED_BY   VARCHAR2(255)  Y
UPDATED_ON   DATE           Y
LAST_UPDATED DATE           Y
CONTENT_TYPE VARCHAR2(128)  Y
BLOB_CONTENT BLOB           Y
LANGUAGE     VARCHAR2(30)   Y
DESCRIPTION  VARCHAR2(4000) Y
FILE_TYPE    VARCHAR2(255)  Y
FILE_CHARSET VARCHAR2(128)  Y

Even though the text file contains character data, the uploaded file content will be stored in the “binary format” in a BLOB column named BLOB_CONTENT. Due to nature of BLOB, to read character out, the conversion using “chr” function is required. Please see a good article about this concept and conversion by Natalka Roshak on the orafaq at http://www.orafaq.com/node/895.

I modified the sample script provided in above article to suite my need – reading each line of the text file and insert into a target table.

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
DECLARE
v_blob_data       BLOB;
v_blob_len        NUMBER;
v_position        NUMBER;
v_raw_chunk       RAW(10000);
v_char      CHAR(1);
c_chunk_len   number       := 1;
v_line        VARCHAR2 (32767)        := NULL;
v_data_array      wwv_flow_global.vc_arr2;
BEGIN
-- Read data from wwv_flow_files
select blob_content into v_blob_data
from wwv_flow_files where name = 'F29800/Data_CSV.csv';
 
v_blob_len := dbms_lob.getlength(v_blob_data);
v_position := 1;
 
-- Read and convert binary to char
WHILE ( v_position <= v_blob_len ) LOOP
 v_raw_chunk := dbms_lob.substr(v_blob_data,c_chunk_len,v_position);
 v_char :=  chr(hex_to_decimal(rawtohex(v_raw_chunk)));
 v_line := v_line || v_char;
 v_position := v_position + c_chunk_len;
-- When a whole line is retrieved
 IF v_char = CHR(10) THEN
-- Convert comma to : to use wwv_flow_utilities
   v_line := REPLACE (v_line, ',', ':');
-- Convert each column separated by : into array of data
   v_data_array := wwv_flow_utilities.string_to_table (v_line);
-- Insert data into target table
   EXECUTE IMMEDIATE 'insert into TABLE_X (v1, v2, v3, v4)
    values (:1,:2,:3,:4)'
    USING
      v_data_array(1),
      v_data_array(2),
      v_data_array(3),
      v_data_array(4);
-- Clear out
   v_line := NULL;
  END IF;
 END LOOP;
END;
/
122 0 / Create an account to join the discussion.