Unable to compile in TOAD (purchased version)

[Salvador Valencia]

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.

I can copy-paste the exact code to a SQL window and it compiled. Also,
selecting the stored. proc. from the Schema Browser list compiles with
no problems.

This is a problem when trying to debug. A co-worker having the same
version had it happened to him also at the same time!

.... Nothing changed, it just failed from one day to the next. So
instead of fighting it we installed the free Toad for now. We will
deal with it later since time pressures do not permit playing around
with it.

I wonder if anybody has found a way to correct this "bug".

Thanks.

[Salvador Valencia]

Thanks Jag, that fixed it.

SV

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.

[Rauf Sarwar]

Originally posted by Salvador Valencia

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.

I can copy-paste the exact code to a SQL window and it compiled. Also,
selecting the stored. proc. from the Schema Browser list compiles with
no problems.

This is a problem when trying to debug. A co-worker having the same
version had it happened to him also at the same time!

... Nothing changed, it just failed from one day to the next. So
instead of fighting it we installed the free Toad for now. We will
deal with it later since time pressures do not permit playing around
with it.

I wonder if anybody has found a way to correct this "bug".

Thanks.

When it comes to code deployment and recompile... nothing beats
sqlplus... works 100% of the time, no fuss or hassles and it comes free
with Oracle installation :->).

Regards
/Rauf Sarwar

--
Posted via http://dbforums.com