Toad World® Forums

PL/SQL Developer Test Window is good, really good


#1

So I was able to run a procedure as an anonymous block, in what I’m guessing was the equivalent of our SE, and the results were displayed in a data grid below - including the results of the sysrefcursor which was one of the OUT parameters. Very cool. Also, I was able to do this because one of our devs sent me their test script that I could load up and run without me having to manually copy and paste the values in the substitution variables. Very cool as well.

Please can you implement these things in TOAD, it’s the #1 reason people give here for using PL/SQL Developer over TOAD. And I can kind of see why (now I have both installed).

Cheers

Richard

Hints and tips on how I could achieve the same in TOAD are most welcome, there’s so much I could have missed it, but it needs to be as easy as:

  1. Send your SE window to someone, including your substitution variables and their values, so they can run it.
  2. Run the script, which includes the anonymous block, and see the results of the sysrefcursor

#2

Richard,

As far as the copy and paste part goes, you can just paste their anonymous block
into the params window right now (instead of pasting each param in the grid).
Unfortunately, the refcursor out won’t display unless you go to the params
window -> Options -> Load into grid from memory. If you select that option,
Refcursor results are displayed on the REF CURSOR results tab once the execution
is finished.

We’ve expanded some of the capabilities of this window for 10.6 but we’re
planning on more improvements as we go.

Greg
Picture (Device Independent Bitmap) 1.jpeg


#3

Oooops…I should have said expanded for 10.5. Fingers are out of synch w/the
brain this morning. Maybe more coffee will help.
Picture (Device Independent Bitmap) 1.jpeg


#4

“you can just paste their anonymous block into the params window right now”

But it doesn’t have their substitution variable in it right? It’s just the SQL with : prefixes but no values associated? PL/SQL Developer includes the values for all of the : variables so I can just load up the test script and execute it using the same variables that my colleague did.

“params window -> Options -> Load into grid from memory”

I have the following anonymous block:

begin
my_package.“my_Proc”(p_var_1 => :v_var_1,
p_sysref_2 => :v_sysref_2);
end;

How do I view the OUT results of :v_sysref_2? I can’t find the option you refer to in either the Options window or the pop-up Variables window.

I’m running the latest beta 10.5.


#5

The Params window has some of it’s own options. It’s the last button
on ghe toolbar.

We don’t do it quite the same way … We declare the variables in the
anonymous block so it looks like a full copy/paste won’t behave the
same way.

On Apr 13, 2010, at 7:22 PM, “r_squires” wrote:

“you can just paste their anonymous block into the params window
right now”

But it doesn’t have their substitution variable in it right? It’s
just the SQL with : prefixes but no values associated? PL/SQL
Developer includes the values for all of the : variables so I can
just load up the test script and execute it using the same variables
that my colleague did.

“params window -> Options -> Load into grid from memory”

I have the following anonymous block:

begin
my_package.“my_Proc”(p_var_1 => :v_var_1,
p_sysref_2 => :v_sysref_2);
end;

How do I view the OUT results of :v_sysref_2? I can’t find the
option you refer to in either the Options window or the pop-up
Variables window.

I’m running the latest beta 10.5.


#6

“It’s the last button on ghe toolbar.”

Which toolbar? What does the button look like? Can I get to it through the menu?


#7

You have to open the params window. It’s the last button on that windows
toolbar.

On Apr 13, 2010, at 7:47 PM, “Richard Squires”
wrote:

Message from: R Squires

“It’s the last button on ghe toolbar.”

Which toolbar? What does the button look like? Can I get to it through the
menu?

Historical Messages

Author: Richard Squires
Date: Tue Apr 13 17:06:09 PDT 2010
“It’s the last button on ghe toolbar.”

Which toolbar? What does the button look like? Can I get to it through the
menu?

__

Author: gregory.liss@quest.com
Date: Tue Apr 13 16:28:30 PDT 2010
The Params window has some of it's own options. It's the last button on ghe
toolbar. We don't do it quite the same way ... We declare the variables in
the anonymous block so it looks like a full copy/paste won't behave the same
way. On Apr 13, 2010, at 7:22 PM, "r_squires" wrote: > "you can just paste
their anonymous block into the params window > right now" > > But it doesn't
have their substitution variable in it right? It's > just the SQL with :
prefixes but no values associated? PL/SQL > Developer includes the values
for all of the : variables so I can > just load up the test script and
execute it using the same variables > that my colleague did. > > "params
window -> Options -> Load into grid from memory" > > I have the following
anonymous block: > > begin > my_package."my_Proc"(p_var_1 => :v_var_1, >
p_sysref_2 => :v_sysref_2); > end; > > How do I view the OUT results of
:v_sysref_2? I can't find the > option you refer to in either the Options
window or the pop-up > Variables window. > > I'm running the latest beta
10.5. > >
__

Author: Richard Squires
Date: Tue Apr 13 15:46:21 PDT 2010
"you can just paste their anonymous block into the params window right now"
But it doesn't have their substitution variable in it right? It's just the
SQL with : prefixes but no values associated? PL/SQL Developer includes the
values for all of the : variables so I can just load up the test script and
execute it using the same variables that my colleague did. "params window ->
Options -> Load into grid from memory" I have the following anonymous block:
begin my_package."my_Proc"(p_var_1 => :v_var_1, p_sysref_2 => :v_sysref_2);
end; How do I view the OUT results of :v_sysref_2? I can't find the option
you refer to in either the Options window or the pop-up Variables window.
I'm running the latest beta 10.5.
__

Author: gregory.liss@quest.com
Date: Tue Apr 13 05:30:09 PDT 2010
Oooops...I should have said expanded for 10.5. Fingers are out of synch
w/the brain this morning. Maybe more coffee will help.
__

Author: gregory.liss@quest.com
Date: Tue Apr 13 05:23:04 PDT 2010
Richard, As far as the copy and paste part goes, you can just paste their
anonymous block into the params window right now (instead of pasting each
param in the grid). Unfortunately, the refcursor out won't display unless
you go to the params window -> Options -> Load into grid from memory. If you
select that option, Refcursor results are displayed on the REF CURSOR
results tab once the execution is finished. We've expanded some of the
capabilities of this window for 10.6 but we're planning on more improvements
as we go. Greg
__

Author: Richard Squires
Date: Mon Apr 12 18:19:50 PDT 2010
So I was able to run a procedure as an anonymous block, in what I'm guessing
was the equivalent of our SE, and the results were displayed in a data grid
below - including the results of the sysrefcursor which was one of the OUT
parameters. Very cool. Also, I was able to do this because one of our devs
sent me their test script that I could load up and run without me having to
manually copy and paste the values in the substitution variables. Very cool
as well. Please can you implement these things in TOAD, it's the #1 reason
people give here for using PL/SQL Developer over TOAD. And I can kind of see
why (now I have both installed). Cheers Richard Hints and tips on how I
could achieve the same in TOAD are most welcome, there's so much I could
have missed it, but it needs to be as easy as: 1. Send your SE window to
someone, including your substitution variables and their values, so they can
run it. 2. Run the script, which includes the anonymous block, and see the
results of the sysrefcursor
__
_______________________________________

#8

image002.png


#9

image001.jpeg


#10

Thanks for that last screenshot, I didn’t want to have to ask again where that was. I wasn’t thinking of executing from the SB, I was looking in the SE. It might be an alternative option to look at.


#11

You don’t have to execute it from the SB to get that window. The elipsis on the editor tool bar brings up the params window as well.



#12

It’s the same place regardless of where you execute from.