Re: Unable to compile in TOAD (purchased version)

From: jag <7bf79m4s02_at_sneakemail.com>
Date: Fri, 08 Aug 2003 17:10:28 -0500
Message-ID: <qi78jvo76a1k1ftukf167035lec42okjsm_at_4ax.com>


On 8 Aug 2003 10:33:13 -0700, salvadorvp_at_yahoo.com (Salvador Valencia) wrote:

>Hi,
>
>I'm getting the message "NO CREATE [OR REPLACE] statement found to
>execute" in the procedure edit window of TOAD (v7.3.0.0). The code
>COMPILED last night and now this morning I get this message. There are
>no syntax errors since we edited and compiled the stored procedure
>successfully on the free Toad.

That's an older version as TOAD is up to 7.5.2.0 now.

According to a SupportLink seach on this, it suggests the following:

"Error "No CREATE [OR REPLACE] statement found to execute" when compiling a procedure. Most likely due to an Object named "PROCEDURE".

Resolution:
TROUBLESHOOT

  1. Go to Tools | Object Search
  2. Type PROCEDURE in the "Search For" box.
  3. Check "Object Names" click search
  4. If there is an object named Procedure TOAD will not allow you to compile any procedures in the Procedure editor. "

If this isn't it, you might want to log an issue with Quest support. Received on Sat Aug 09 2003 - 00:10:28 CEST

Original text of this message