Stack Overflow
Stack Overflow

Questions tagged [toad]

Toad is a database query tool from Quest Software. There are versions of Toad that can query Oracle, SQL Server, MySQL, PostgreSQL and more. It provides query editing & reporting, debuggers, performance analyzers and many other tools.

Toad is a database query tool from Quest Software. There are versions of Toad that can query Oracle, SQL Server, MySQL, PostgreSQL and more. It provides query editing & reporting, debuggers, performance analyzers and many other tools.

This tag should be used for questions regarding how to use Toad software.

1263 questions
10
votes
13 answers

Is it possible to export saved passwords from Toad

I'm looking for a way to export saved usernames/passwords from Toad for Oracle (9.5.0.31). It doesn't have to be in a usable format for importing - even a plaintext format would be fine. I believe the passwords are stored encrypted in…
Joe Enos
  • 39,478
  • 11
  • 80
  • 136
10
votes
4 answers

How to get my PUT_LINE statement to display in TOAD?

This code compiles, but in TOAD it won't show the "hi wo" output CREATE OR REPLACE PROCEDURE AdelTest IS tmpVar NUMBER; BEGIN DBMS_OUTPUT.ENABLE(100: in INTEGER); DBMS_OUTPUT.PUT_LINE('hi wo'); tmpVar := 0; EXCEPTION WHEN…
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
10
votes
2 answers

How to display a sys_refcursor data in TOAD's DataGrid

Please i need help. (I SEARCHED A lot and get more confused . ) I use Toad 9.7.25 and i made this procedure (in a package) PROCEDURE ReportaCC(pfcorte IN DATE, lcursor IN OUT SYS_REFCURSOR) IS BEGIN OPEN lcursor FOR select c1, c3, c3…
Edgar Fco Delgado Zamarripa
  • 190
  • 1
  • 2
  • 11
9
votes
1 answer

ORA-00932: inconsistent datatypes: expected - got -

I have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I have tried to use the ref cursors and collection types for the first time. And I 've searched the web, when I faced with problems, and this…
Duygu Akyol
  • 93
  • 1
  • 1
  • 4
9
votes
5 answers

Variables in TOAD scripts

I have a SQL script that is being executed in TOAD. Currently, I have it laid out with just statement after statement, thusly: select such-and-such from somewhere; delete other-thing from somewhere-else; And so on. Some of the where clauses end…
RationalGeek
  • 9,425
  • 11
  • 62
  • 90
8
votes
3 answers

How do I get the return value from a function in Oracle using Toad

How do I find out in Toad what the return value of a function is? I'm running something like this code: declare r number; begin r:= packagename.functionname(paraname); end; I can't work out how to get "r" returned to the data grid, some posts…
Stagg
  • 2,660
  • 5
  • 34
  • 32
8
votes
1 answer

How to open multiple viewer windows in Toad?

Im sure this is pretty simple but I just cant seem to find the option. My Toad MySql install only seems to allow me to have one "Viewer" window open and hence its impossible to view multiple tables - or have a window open for each table Im working…
Remotec
  • 10,304
  • 25
  • 105
  • 147
8
votes
5 answers

How to prevent toad disconnecting its session after some time?

I am using toad for oracle client. In which the session disconnects after some time. How to make it enabled at all time.
VINOTH ENERGETIC
  • 1,775
  • 4
  • 23
  • 38
8
votes
2 answers

Calling a stored PROCEDURE in Toad

I have a defined a new stored procedure but get a error while calling it, CREATE OR REPLACE PROCEDURE SCOTT.getempsal( p_emp_id IN NUMBER, p_emp_month IN CHAR, p_emp_sal OUT INTEGER) AS BEGIN SELECT EMP_SAL INTO…
user1050619
  • 19,822
  • 85
  • 237
  • 413
8
votes
2 answers

Toad problems with comments

I have problems with the comments in Toad. I copied a few lines of code from the notepad to Toad and generate strange characters. UPDATE: I got this problem while working from a remote desktop via a VPN. Any suggestions? Thanks.
alditis
  • 4,633
  • 3
  • 49
  • 76
8
votes
5 answers

how to create an insert script from a table using TOAD, oracle?

I used TOAD for oracle 11g, I want to create an insert script from a table. or I want to create a script file that allows eclipse to rebuild the entire database with their data.
Karim Oukara
  • 2,638
  • 8
  • 38
  • 51
8
votes
11 answers

TOAD for Oracle and Windows 7: Can't initialize OCI. Error -1

I have a problem with TOAD for Oracle 9.1 running on Windows 7 32-bit, described as follows: I have Oracle OraClient10g 10.0.2 installed on my PC, and I need to use Toad 9.1. When I try to log into a server, I specify the database via TNS, I type…
DMolinaVzla
  • 91
  • 1
  • 1
  • 4
7
votes
1 answer

Why do I get 'Binary logging not possible.' on my MySQL server?

When I started up my MySQL server today and try to do some changes using Toad for Mysql, I get this message: MySQL Database Error Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode…
Steven
  • 19,224
  • 47
  • 152
  • 257
7
votes
1 answer

Does SQLDeveloper have a tool to copy/clone users like Toad?

Does SQLDeveloper have a Toad-like tool to copy/clone an Oracle database user? If not, I'll resort to: How to Clone a User in Oracle
Ultimadj
  • 83
  • 1
  • 1
  • 5
6
votes
4 answers

Toad for Oracle - changing formatting on DBMS Output window

On the DBMS Output window for Toad v11, how can you change the DBMS Output font and color? I've looked all over in the options but I'm unable to find where it's possible it change this. It's way too small by default.
Major Major
  • 2,697
  • 3
  • 27
  • 35
1 2
3
…
84 85