SupportSupport

Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: possible to find line number for error?

Welcome, Guest: Login / Register; Guest Settings

Reply to this Thread

Search Forum

Back to Thread List

	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

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,254
Registered: 10/11/06

Re: possible to find line number for error?
Posted: Apr 18, 2008 11:04 PM

in response to: Jimmy

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

in response to: Hans Bergsten

Hi Hans,

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

Thanks.
Jimmy

Roger Bjarevall

Posts: 4,563
Registered: 12/17/04

Re: possible to find line number for error?
Posted: Apr 19, 2008 8:51 AM

in response to: Jimmy

Jimmy,

Please check the following web page:

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

Regards

Roger

Ray Koski

Posts: 2
Registered: 04/25/08

Re: possible to find line number for error?
Posted: Apr 25, 2008 5:52 PM

in response to: Roger Bjarevall

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,254
Registered: 10/11/06

Re: possible to find line number for error?
Posted: May 21, 2008 12:02 AM

in response to: Ray Koski

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: 2
Registered: 04/25/08

Re: possible to find line number for error?
Posted: Jun 12, 2008 10:19 PM

in response to: Hans Bergsten

Ok, thanks very much.

Pages: 1

Back to Thread List