Toad for Oracle Forum - Toad for Oracle - Toad World
Danny Torres
Follow / 16 Jan 2017 at 8:21pm / Toad for Oracle

Hashtag game! Tomorrow, let's make #ToadTuesday trend!

Expand content
Hi All, 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...

Hi All,

 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!

352 0 / Create an account to join the discussion.
Danny Torres
Follow / 1 Nov 2016 at 1:48pm / Toad for Oracle

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
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

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

738 0 / Create an account to join the discussion.
Danny Torres
Follow / 14 Sep 2016 at 5:03pm / Toad for Oracle

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.

1249 0 / Create an account to join the discussion.
tom.wickerath
Follow / 18 Apr 2017 at 12:39am / Toad for Oracle
Latest post by on 27 Apr 2017 at 9:12am

Line Numbers for PL/SQL code

Expand content
Hello - Using TOAD for Oracle, version 12.10.0.30. 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...

Hello -

Using TOAD for Oracle, version 12.10.0.30. When I encounter a PL/SQL error, which sadly is very often as I'm a newbie Smile 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:

Second Question

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.

Thank You,

Tom


/* 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 find
the 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;
/

Answered 1030 58 / Create an account to join the discussion.
Jonny1
Follow / 26 Apr 2017 at 2:26pm / Toad for Oracle
Latest post by on 26 Apr 2017 at 2:39pm

Creating Unit Tests

Expand content
Hi 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...

Hi

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

Thanks

Answered 58 2 / Create an account to join the discussion.
neldeon
Follow / 25 Apr 2017 at 1:54pm / Toad for Oracle
Latest post by on 25 Apr 2017 at 3:32pm

TOAD Base Edition Trial

Expand content
Hi, 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...

Hi,

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

Deon

68 2 / Create an account to join the discussion.
Dave_H2
Follow / 25 Apr 2017 at 1:59pm / Toad for Oracle

TOAD 12.10.0.30. Formatting Options

Expand content
Hello All, I have a question about Formatting Options in TOAD 12.10.0.30. 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...

Hello All,

I have a question about Formatting Options in TOAD 12.10.0.30.

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       
 IN OUT

Current FmtPlus.opt

[Qp5FormatterOptions]
Version=296
RightMargin=120
AssignFavorWrapping=0
ConcatStyle=1
ConcatOperatorPos=2
Tagline=0
OutputTabs=4
IndentSize=4
InsertTabs=0
DmlColumnAliasAlignment=1
DmlTableRefAliasAlignment=1

Thanks

Dave

Unanswered 30 0 / Create an account to join the discussion.
ozzjack
Follow / 17 Mar 2016 at 5:16am / Toad for Oracle
Latest post by on 24 Apr 2017 at 9:06pm

Enable 'Toggle Compiling with debug'

Expand content
Hi All, 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...

Hi All,

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.

4010 3 / Create an account to join the discussion.
john.c.rose
Follow / 24 Apr 2017 at 3:21pm / Toad for Oracle
Latest post by on 24 Apr 2017 at 4:52pm

Application Data Directory Lost

Expand content
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...

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

Answered 76 3 / Create an account to join the discussion.
adiemoran
Follow / 21 Apr 2017 at 11:30am / Toad for Oracle
Latest post by on 24 Apr 2017 at 3:15pm

Bug in Oracle to ANSI join conversion?

Expand content
Hi everybody, 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...

Hi everybody, 

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

FROM S01_PERSO

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_AGCLE
and 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_DOCTORNAME
FROM S01_PERSO
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 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 12.10.0.30, 64 bit on Windows 7 64 bit.

Thanks in advance.

Andy

Answered 162 6 / Create an account to join the discussion.
AkshataR
Follow / 7 Feb 2017 at 7:08pm / Toad for Oracle
Latest post by on 24 Apr 2017 at 8:17am

Access voilation at address errors

Expand content
Hello All, Tool details: Toad for Oracle Toad for oracle Xpert(64-bit),Add-Ons: DB Admin Module. Version : 12.8.0.49 Issue: Have been facing issue with total lately with export data/create...

Hello All,

Tool details:

Toad for Oracle

Toad for oracle Xpert(64-bit),Add-Ons: DB Admin Module.

Version : 12.8.0.49

Issue:

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?

Thank you,

Akshata R

Unanswered 284 2 / Create an account to join the discussion.
piombo
Follow / 22 Apr 2017 at 7:58pm / Toad for Oracle

Keeping Number Data Types From Becoming Text Data Type When Exporting...

Expand content
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....

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 12.10.0.30
I dread having to convert all my files impacted.  Is there a Toad Option to keep numbers as numbers when exporting?

Unanswered 52 0 / Create an account to join the discussion.
sherrie.kubis
Follow / 21 Apr 2017 at 8:21pm / Toad for Oracle

Row Height in Data Grid on Editor Tab

Expand content
TOAD 12.10.0.30 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...

TOAD 12.10.0.30

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? 

48 0 / Create an account to join the discussion.
ServiceAccount_Toad
Follow / 21 Apr 2017 at 4:43pm / Toad for Oracle
Latest post by on 21 Apr 2017 at 5:49pm

Visual Studio Online - Team Coding

Expand content
Is there documentation for Team Coding via Visual Studio Online (TFS) using version 12.10.030 of Toad?
Is there documentation for Team Coding via Visual Studio Online (TFS) using version 12.10.030 of Toad?
Unanswered 80 1 / Create an account to join the discussion.
tom.wickerath
Follow / 18 Apr 2017 at 12:03am / Toad for Oracle
Latest post by on 21 Apr 2017 at 8:48am

Adding commas when double-clicking columns in Editor?

Expand content
Hello - I am using TOAD for Oracle, version 12.10.0.30. 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...

Hello -

I am using TOAD for Oracle, version 12.10.0.30. 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.

Thank You,

Tom

Unanswered 141 5 / Create an account to join the discussion.
ServiceAccount_Toad
Follow / 20 Apr 2017 at 8:53am / Toad for Oracle
Latest post by on 20 Apr 2017 at 1:58pm

How is the data fetch limit determined at schema level?

Expand content
Hi, 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 12.1.0.22. I could not find parameters "Limit Grid Fetch"...
Hi,

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 12.1.0.22. 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?

Thanks,
Ayyappan
Unanswered 70 1 / Create an account to join the discussion.
akashivi
Follow / 20 Apr 2017 at 8:58am / Toad for Oracle

Data Grid Fetch - control limit at schema level

Expand content
Hi, 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 12.1.0.22. I could not find parameters "Limit Grid Fetch" or "OCI...

Hi,

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 12.1.0.22. 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?

Thanks,
Ayyappan

55 0 / Create an account to join the discussion.
bhavesh.shah_18619
Follow / 18 May 2016 at 4:06pm / Toad for Oracle
Latest post by on 19 Apr 2017 at 8:51pm

The procedure entry point ons_error_set could not be located in the...

Expand content
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...

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

Unanswered 1753 1 / Create an account to join the discussion.
crobinson1165
Follow / 27 Feb 2015 at 9:06pm / Toad for Oracle
Latest post by on 18 Apr 2017 at 8:16pm

Using Kerberos with Toad

Expand content
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...

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?

3127 4 / Create an account to join the discussion.
Dale.Raar
Follow / 18 Apr 2017 at 1:02pm / Toad for Oracle

Extract table names from SQL script

Expand content
Is there a way to quickly extract all of the table names used in a long SQL script file?
Is there a way to quickly extract all of the table names used in a long SQL script file?
Unanswered 53 0 / Create an account to join the discussion.