Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: possible to find line number for error?


Permlink Replies: 6 - Pages: 1 - Last Post: Jun 12, 2008 10:19 PM Last Post By: Ray Koski
Jimmy

Posts: 3
Registered: 04/17/08
possible to find line number for error?
Posted: Apr 18, 2008 7:30 PM
   thread.click_reply Reply
I'm working with an anonymous pl/sql block. When the block has errors, it says what the error is, but not the line(s) that the error occurs on. Is it possible to have the line number reported alongside the error? It would save me some time in figuring out where the error is if the line number was reported.

Thanks!
Hans Bergsten


Posts: 1,496
Registered: 10/11/06
Re: possible to find line number for error?
Posted: Apr 18, 2008 11:04 PM    global.in_response_to.tooltip in response to: Jimmy
   thread.click_reply Reply
Hi Jimmy,

The error message comes straight from the database, and unfortunately, most databases do not include a line number.

Which database do you use? If it is one of the database with "extended support", you may want to try out the new procedure editor in the 6.1.1.2 EA release:

http://www.minq.se/products/dbvis/eap/

For databases that report the line number, clicking on an error message highlights the corresponding line in the procedure editor.

Best Regards,
Hans
Jimmy

Posts: 3
Registered: 04/17/08
Re: possible to find line number for error?
Posted: Apr 19, 2008 4:46 AM    global.in_response_to.tooltip in response to: Hans Bergsten
   thread.click_reply Reply
Hi Hans,

I am running oracle 9. Where can I find which databases have extended support?

Thanks.
Jimmy
Roger Bjarevall


Posts: 4,995
Registered: 12/17/04
Re: possible to find line number for error?
Posted: Apr 19, 2008 8:51 AM    global.in_response_to.tooltip in response to: Jimmy
   thread.click_reply Reply
Jimmy,

Please check the following web page:

http://www.minq.se/products/dbvis/features/features.jsp?feature=9

Regards

Roger
Ray Koski

Posts: 4
Registered: 04/25/08
Re: possible to find line number for error?
Posted: Apr 25, 2008 5:52 PM    global.in_response_to.tooltip in response to: Roger Bjarevall
   thread.click_reply Reply
I would like to expand on Jimmy's question. In the Log window where the errors are reported, there is an icon that precedes the error description (it looks like a yellow piece of paper). I have clicked on that icon and what seems to happen is it hides or deletes much of my source code, presumably attempting to show me where the error is located. I have lost much code this way and had to rewrite it because I can't figure out how to get the code to re-appear in the SQL Commander window
Any suggestions?
Hans Bergsten


Posts: 1,496
Registered: 10/11/06
Re: possible to find line number for error?
Posted: May 21, 2008 12:02 AM    global.in_response_to.tooltip in response to: Ray Koski
   thread.click_reply Reply
Hi Ray,

I'm looking into this now. We will change it so that when you click on the icon, the corresponding statement will be selected in the editor without removing any of the surrounding statements.

Best Regards,
Hans
Ray Koski

Posts: 4
Registered: 04/25/08
Re: possible to find line number for error?
Posted: Jun 12, 2008 10:19 PM    global.in_response_to.tooltip in response to: Hans Bergsten
   thread.click_reply Reply
Ok, thanks very much.

Point your RSS reader here for a feed of the latest messages in all forums