Toad World® Forums

Un-helpful error message


#1

Running Toad 9.7.2.5. I know there are bugs in this version and I am wondering if this is another. When I try and compile my procedure I get “Warning: compiled but with compilation errors”, but the little "description window does not pop-up. That is all I have to go on. The problem ended up being a structure issue with the procedure. I had

CREATE OR REPLACE PROCEDURE FixBrokenLines2 IS

Blah Blah

END FixBrokenLines; – Without the “2”

Is Oracle/Toad incapable of giving a better error message? This is not the first instance where I have gotten this “unhelpful” message. What I had to do last time was comment out lines 1 by 1 until I discovered it. This time I started started down that path (tedious).


#2

Executing as a script (F5), you receive the same error in Toad as you would in SQLPlus. That is by design since F5 functionality is there to emulate SQLPlus
as closely as possible.

Try using F9 instead. I can’t remember back to the 9.7 days but in 11.0+ versions, you get a much more descriptive error message.

Greg

From: Bartron [mailto:bounce-Bartron@toadworld.com]

Sent: Thursday, October 23, 2014 8:48 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Un-helpful error message

Un-helpful error message

Thread created by Bartron

Running Toad 9.7.2.5. I know there are bugs in this version and I am wondering if this is another. When I try and compile my procedure I get “Warning: compiled but with compilation errors”,
but the little "description window does not pop-up. That is all I have to go on. The problem ended up being a structure issue with the procedure. I had

CREATE OR REPLACE PROCEDURE FixBrokenLines2 IS

Blah Blah

END FixBrokenLines; – Without the “2”

Is Oracle/Toad incapable of giving a better error message? This is not the first instance where I have gotten this “unhelpful” message. What I had to do last time was comment out lines 1 by 1 until I
discovered it. This time I started started down that path (tedious).

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#3

Isn’t the offending line highlighted when you compile it? It is for me.


#4

Gregory, F9 does nothing.

John, Only centers the line I was on originally (which is high-lighted).


#5

On F9 the parser has probably caught the syntax error and Toad is blocking the execution. That was the case for a release or two and it has since been changed to send the statement to Oracle even if the parser indicates error. It’s been fixed in a newer release.