newbie can't see dbms_output

[Colin McKinnon-2]

Hi All,

I'm evaluating SquirrelSQL as a tool for doing Oracle dev work.

Mostly I've managed to get it to do what I want, but I'm not able to see the results of calls to dbms_output.put_line.

I read through http://www.nabble.com/Script-not-executed%2C-although-Oracle-SQLPlus-could-do-it-td7358034.html#a7358034
and although I have the Oracle plugin installed, I can't see the buttons referenced.

I'm using v3.0.2. Running simple select queries works as expected.

Running

begin
dbms_output.put_line(sys_context('userenv','instance_name'));
end;
/

Just gives me "Query 1 of 1 elapsed time (seconds) - Total: 0, SQL query: 0, Building output: 0" in the bottom pane.

anybody got any ideas what's going wrong or how to proceed?

TIA

C.
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[manningr]

Hi Colin,

The Oracle toolbar appears in the SQL tab for the Oracle
session (see attached image which contains the four
Oracle toolbar icons between the "select current sql"
and "Find" icons).

When you click on the first of the icons
"View Oracle Database Output", you will see a new
window popup that contains an area where output is
displayed.  You must execute the procedure, then
click the refresh button (or enable auto-refresh) in the
output window.

Rob

On Tue, Oct 20, 2009 at 4:28 AM,  <colin.mckinnon@...> wrote:

> Hi All,
>
> I'm evaluating SquirrelSQL as a tool for doing Oracle dev work.
>
> Mostly I've managed to get it to do what I want, but I'm not able to see the
> results of calls to dbms_output.put_line.
>
> I read through
> http://www.nabble.com/Script-not-executed%2C-although-Oracle-SQLPlus-could-do-it-td7358034.html#a7358034
> and although I have the Oracle plugin installed, I can't see the buttons
> referenced.
>
> I'm using v3.0.2. Running simple select queries works as expected.
>
> Running
>
> begin
> dbms_output.put_line(sys_context('userenv','instance_name'));
> end;
> /
>
> Just gives me "Query 1 of 1 elapsed time (seconds) - Total: 0, SQL query: 0,
> Building output: 0" in the bottom pane.
>
> anybody got any ideas what's going wrong or how to proceed?
>
> TIA
>
> C.
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Colin McKinnon-2]

Thanks Robert - yes its working exactly as you describe.

On Oct 20, 2009 11:16am, Robert Manning <robert.m.manning@...> wrote:

> Hi Colin,
>
>
>
> The Oracle toolbar appears in the SQL tab for the Oracle
> session (see attached image which contains the four
> Oracle toolbar icons between the "select current sql"
> and "Find" icons).
>
> When you click on the first of the icons
> "View Oracle Database Output", you will see a new
> window popup that contains an area where output is
> displayed.  You must execute the procedure, then
> click the refresh button (or enable auto-refresh) in the
> output window.
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users