Toad World® Forums

Beta Released (12.11.0.52)

Beta Notes

Editor - Debugger

Execute PL/SQL - Set Parameters

Input argument values can be set to SELECT statements. Set the argument’s type to expression and its value to a SELECT that returns a single column and single row.

Dennis,

I'm on Beta 53 now and I wanted to try this feature.
So I entered

select *
from dual
where dummy = :x;

Then pressed F9 and got the following pop-up:

I can see only the options to specify a literal or an environment variable.
No expression option :frowning:

Am I missing something?

Abe Kornelis

Hi Abe,

This feature is available when debugging (Set Parameters and Execute window) - see below.