User defined tools - configuration?

[deekay]

Hi!

I need help to configure an user defined tool -
my settings so far:

Tab General:
Descritpion: Sample
Type: Session
Exe/script: c:\scripts\sample.sql
Parameters:
Default Path:

Tab Button:
Checked 'Toolbar Button'
Description: Sample
Image: random

Tab Options:
Checked 'Active Connection', 'SQL Window', 'Test Window'

Sample script:
begin
DBMS_OUTPUT.PUT_LINE('FOOBAR');
end;

I tried to execute the sample script in a SQL Window (active connection to database), but nothing happens at all.

Any ideas anyone?

 

[Marco Kalter]

The PL/SQL Block writes 'FOOBAR' to the output buffer. If you subsequently run something in the SQL Window, the text should be displayed on the Output tab page.

 

[Theod]

Hi Marco,

this problem should be known, but is not jet solved.

http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=004488;p=1#000004

But I've just found, that the output is send to the Output-Tab but is not visible .

1. Open an sql-window
2. Start the Script per Button
3. nothing happens
4. Execute a query in the same window (select * from dual)
5. On the output tab is 'FOOBAR' from the script
On the sql tab is 'X' from the query

 

[Marco Kalter]

Ah, yes. That's because the SQL Window session is not yet created when the SQL Window is first opened.

 

[Theod]

Ok,

is this a bug or a feature?

 

[Marco Kalter]

It's a bug.