Subject: scriptrunner and bind variables question -
msg#00544

Previous Message by Date:

Re: Profiler Help

Hi Katherine, i remember some beta version where this problem occurs, in .24 it works right for me. (with grant select any table to the user where prof ids installed) so i recommand downloading the latest beta... hope this helps Matthias --- In toad@xxxx, Katherine Scott <katherine.scott@xxxx> wrote: > > Is it showing "0" on the graph, or also in the statistics at the bottom? > > -----Original Message----- > From: Chris Boyle [mailto:cboyle@xxxx] > Sent: Thursday, September 19, 2002 10:24 AM > To: 'toad@xxxx' > Subject: [toad] Profiler Help > > > I finally got the profload.sql and toadprofiler.sql scripts run. I am > executing the procedure with the profiler active. It takes 3-4 minutes to > execute but it keeps displaying a time of 0.0 against all of the lines. I > have timed statistics turned on. Is there something else I need to do in > order to see execution times? > > To download the beta: http://www.toadsoft.com/beta.zip > To unsubscribe, mailto:toad-unsubscribe@xxxx > Archives: http://www.yahoogroups.com/list/toad > > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ To download the beta: http://www.toadsoft.com/beta.zip To unsubscribe, mailto:toad-unsubscribe@xxxxxxxxxxxxxxx Archives: http://www.yahoogroups.com/list/toad Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Next Message by Date:

RE: Re: Profiler Help

It is showing 0 in both places Toad 7.3 with DBA options Oracle 8.1.6 --- In toad@xxxx, Katherine Scott <katherine.scott@xxxx> wrote: > > Is it showing "0" on the graph, or also in the statistics at the bottom? > > -----Original Message----- > From: Chris Boyle [mailto:cboyle@xxxx] > Sent: Thursday, September 19, 2002 10:24 AM > To: 'toad@xxxx' > Subject: [toad] Profiler Help > > > I finally got the profload.sql and toadprofiler.sql scripts run. I am > executing the procedure with the profiler active. It takes 3-4 minutes to > execute but it keeps displaying a time of 0.0 against all of the lines. I > have timed statistics turned on. Is there something else I need to do in > order to see execution times? > > To download the beta: http://www.toadsoft.com/beta.zip > To unsubscribe, mailto:toad-unsubscribe@xxxx > Archives: http://www.yahoogroups.com/list/toad > > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ To download the beta: http://www.toadsoft.com/beta.zip To unsubscribe, mailto:toad-unsubscribe@xxxxxxxxxxxxxxx Archives: http://www.yahoogroups.com/list/toad Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ To download the beta: http://www.toadsoft.com/beta.zip To unsubscribe, mailto:toad-unsubscribe@xxxxxxxxxxxxxxx Archives: http://www.yahoogroups.com/list/toad Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Previous Message by Thread:

minor bug in the DBA module

Beta: 7.4.9.24   Dba-->Kill/Trace Session   If you click on the session and then use "Kill the selected session" item on the toolbar - it works. If you right click on the session and select "Kill User" - it does nothing.   The same apply to "Start trace for this session" and "Stop trace for this session" options. They both work from the toolbar, but not from the context menu.   To download the beta: http://www.toadsoft.com/beta.zip To unsubscribe,  mailto:toad-unsubscribe@xxxxxxxxxxxxxxx Archives: http://www.yahoogroups.com/list/toad Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Next Message by Thread:

Re: scriptrunner and bind variables question

That's a Jim question. Since the goal is to replace SQL Plus, I would hazard a guess that the answer is yes. Jim ??? --- In toad@xxxx, "Matthias Kroll" <matthias.kroll@xxxx> wrote: > Hi, > to make the runner an equivalent to sqlplus > i'm missing the support of bind variables eg: > > > SET serverout ON > > var COL NUMBER > DECLARE > i NUMBER; > BEGIN > SELECT USERENV('SESSIONID') INTO i FROM dual ; > --select pd_id into i from productnode where mkz='&tell_mkz'; > :COL := i; > END; > / > print COL > --select * from pndata where pd_id=:col; > > ....only an example ..i want to select any data and then > use the result COL within following statements. > > Do you plan to support bind variables sqlplus like? > > > Matthias To download the beta: http://www.toadsoft.com/beta.zip To unsubscribe, mailto:toad-unsubscribe@xxxxxxxxxxxxxxx Archives: http://www.yahoogroups.com/list/toad Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/