DBMSOUTPUT window and error window

[sparhawk]

I just downloaded PLSQL Devloper for evaluation in our company and so far I like it. The only two issues I found so far are the following.

1.) When I open an SQL browser window I get also a tab with the dbms output window. However when I develop a PLSQL program I don't see such a tab or option to make it visible. Since I use plsql for small reports I need this. I can put the plsql into an sql window to achieve that, but then I don't have the editing functions available. Am I doing something wrong or do I miss something here?

2.) When executing a PLSQL script, and there are some errors, then I get a messagebox telling me the errors. This means that I have to memorize, write down or screenshot this info in order to fix it, because I have to close the messagebox before I can edit the script. Is there some status window that keeps track of the errors which is available after closing the messagebox?

Thanks for any hints on these issues.

 

[sparhawk]

Another (minor) issue I found is no line numbers in the SQL Window.

 

[Marco Kalter]

1.) When I open an SQL browser window I get also a tab with the dbms output window. However when I develop a PLSQL program I don't see such a tab or option to make it visible. Since I use plsql for small reports I need this. I can put the plsql into an sql window to achieve that, but then I don't have the editing functions available. Am I doing something wrong or do I miss something here?

Editing and compiling a PL/SQL program will not lead to dbms_output. Running a PL/SQL program might, and for this you can use the Test Window, which also has a dbms_output tab page. See also chapter 4 in the User's Guide.

2.) When executing a PLSQL script, and there are some errors, then I get a messagebox telling me the errors. This means that I have to memorize, write down or screenshot this info in order to fix it, because I have to close the messagebox before I can edit the script. Is there some status window that keeps track of the errors which is available after closing the messagebox?

In a Test Window and SQL Window, the cursor will be located at the error position. The first line of the error message is displayed on the status line of the window.