Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
'ORA-24344 success with compilation error' - Unable to create procedures from Toad when execu
Description
When running the query (as shown below) in Toad 10.6.1 with the execute/compile button, ctrl+enter or Shift+ F9 works fine.
If the cursor is placed on/inside the statement and the “/” is removed and it is executed with ctrl+enter or Shift+ F9 , it fails and returns error message 'ORA-24344 success with compilation error'.
CREATE OR REPLACE procedure mytest1 as begin dbms_output.put_line('hello world'); end; /
Resolution
WORKAROUND: Execute the create procedure with execute/compile button
STATUS: Waiting for fix in a future release of Toad for Oracle
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
Toad for Oracle
Topic(s):
Technical Solutions
Article History:
Created on: 11/18/2010 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.