title: Oracle Apex: ORA-24344 Success with compilation error
body: <p>I am currently working on an oracle database in APEX.</p>
  
  <p>First of all, I do not have access to any tools. I can only use what is provided in apex.oracle.com and I am writing the script in NotePad++ before uploading it over there. It's a school assignment, so I am not allowed to use any other tools, even if there is something that would make things easier.</p>
  
  <p>I am creating a long script that creates a bunch of tables in a database, creates a bunch of records in every table, and creates all the constraints. This part works fine. Now i must create several functions and procedures in the same script, after the other stuff.</p>
  
  <p>Every single time I try to create one, I get this: ORA-24344: success with compilation error</p>
  
  <p>Also, the other instructions in the script after this error are not executed. Everything that was before the error works fine.</p>
  
  <p><a href="https://i.stack.imgur.com/BQ4w8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BQ4w8.png" alt="http://i.imgur.com/lHIjfcE.png"></a></p>
  
  <p>Here is one of the functions that create this error:</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION SP_03Recherche (titre_art VARCHAR2, nom_aut VARCHAR2, type_art VARCHAR2)
  RETURN CURSOR
  IS
      CURSOR articles (p_titre_art VARCHAR2, p_nom_aut VARCHAR2, p_type_art VARCHAR2) IS
      SELECT * FROM BI_Articles INNER JOIN (BI_ArticlesAuteurs INNER JOIN BI_Auteurs ON BI_ArticlesAuteurs.AuteurID = BI_Auteurs.AuteurID) ON BI_Articles.ISBN = BI_ArticlesAuteurs.ISBN
      WHERE (Titre LIKE p_titre_art) AND ((Nom LIKE p_nom_aut) OR (Prenom LIKE p_nom_aut)) AND TypeArticle LIKE type_art;
  BEGIN
      RETURN articles(titre_art, nom_aut, type_art);
  END;
  </code></pre>