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.