Unable to compile in TOAD (purchased version)

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Salvador Valencia
    #1

    Unable to compile in TOAD (purchased version)

    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.
    Tags: None
    • Salvador Valencia
      #2
      Re: Unable to compile in TOAD (purchased version)

      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.

        Comment

        • Rauf Sarwar
          #3
          Re: Unable to compile in TOAD (purchased version)


          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

            Comment

            Previous template Next
            Working...