John, Make sure to check out and set the Schema Browser Filters option under the Session Menu prior to opening the SB. Also turn on the Num Rows in the SB as...
Patrick McGrath
Patrick.mcgrath@...
Jan 1, 2007 2:04 pm
35365
To amplify John's response: Whenever you create a new Oracle Home it includes a subdirectory called "network" (or in older versions, net80) and beneath that, a...
Installing the 10G Developer Suite would have created a new Oracle Home directory on your C: drive. You're probably defaulting to using that Oracle Home, and...
Hi, I'm new to Toad. I have a stored procedure which returns a 'ref cursor' as an 'out' parameter. Is it possible to call such a procedure from TOAD, and make...
Morning Mark, ... Scary, very scary. My wife loves it though and has sent it to all our friends in Australia. I feel I may be getting some 'ribbing' from the ...
Hi John, ... get ... Now the help for 9.0 doesn't mention that SubVersion is usable with TOAD. Have you set it up for TOAD's use then ? If so, would you be so...
Hi 'arvind.krs', ... I'm afraid I don't use (and never have used) Pro*C with Oracle, so I'm unable to advise you on any books on the subject - sorry. Having...
Hi, TOAD's debugger has support for REF CURSORs, but AFAIK only for "Strongly Typed" RCs, that have been declared in a package: create or replace package...
Patrick, I was not able to reproduce any problem (or I am misunderstanding your email). Here is what I did: 1) Open SB. Changed the filter to only show...
Yes this is possible but I believe you will need the debugger option according to the Toad Help. Here is an example - I created this package.... create or...
Hi Bert, just wondering if you have managed to find any time to progress with the 'teaser' you sent us recently ? Cheers, Norm [TeamT] Norman Dunbar. Contract...
Afternoon Harry, ... MS Query Analyzer that automatically capitalizes >> key words. Does TOAD have something that does the same thing? Yes. ... Ok, here you...
... Thanks Bert. Has your book been published yet ? Cheers, Norman. Norman Dunbar. Contract Oracle DBA. Rivers House, Leeds. Internal : 7 28 2051 External :...
the benchmarking book is supposed to go out Q1 07 - but we printed off some advance copies that were handed out at open world. as for the data modeling book -...
Morning Bert, ... off some advance ... I didn't know you had a benchmarking book 'coming soon'. Hmmm ..... ... get backing since people ... What do they know?...
I have just tried Toad 9.0.1 Schema Doc Generator and I found something strange. When looking at an individual package, the code is 'center justified' instead...
Hi Many Thanks for providing me this link... BTW, HAPPY NEW YEAR... ... -- With Kind Regards, ARVIND KUMAR Tata Consultancy Services Limited Plot-C, Block-EP,...
Thanks Norman. I am glad to see that it does change any code I have already created. I really appreciate all the help I have received from this group. Harry...
Hi Solmyr72, At my company we have just converted a few hundred Sybase stored procedures and functions to Oracle procedures using reference cursors. Below is a...
Hi, I use TOAD 8.6 I have created the user TOAD ( with wizard ) In session brouwser I gan get explain plan from any user except from one user I droped TOAD...
Thierry CONSTANT
thierry.constant1@...
Jan 3, 2007 2:02 pm
35386
sounds like that one user doesn't have privileges on the plan_table, or maybe some of the tables in the query that you're trying to do an explain plan on. I...
Hi Ian, ... something ... I've just tried this using 9.0.1.8 and 9.1.0.5 Beta, and both show the code in my packages exactly as I typed them in. I wonder if...
It still looks left Justified here, Ian. There's no setting for it. Are you using your own css file? Maybe something in there could have cause it. Send me...
Hmm, it's interesting, that the string "P_FROZEN_PROD_ AVAILABLE" has a blank before "AVAILABLE". Did anyone notice that? But anyway, the source code seems to...
Key mapping: - No help on Key-mapping (except on how to enter the Dialog) from Help menu. - F1 does not bring any help window as well. - Some keys cannot map....
Yuval Ben Tal
Yuval.BenTal@...
Jan 4, 2007 2:00 pm
35391
ok, The next beta will (optionally) run pl/sql blocks to check for views and mviews which reference db links. ... From: toad@yahoogroups.com...
Hi, I have two procedures with the same name but different number of parameters: PROCEDURE usp_trace_msg( in_message IN CLOB DEFAULT NULL, ...
Chaitanya Chandra
Chaitanya.Chandra@...
Jan 5, 2007 1:10 am
35393
Norman / John .. thanks for the replies .. you were both on the money. I deleted the .css file .. and recreated everything from scratch .. and it worked Ok. ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
