How to fix error on procedure creation?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Haithem Souala
    New Member
    • Jan 2011
    • 2

    How to fix error on procedure creation?

    Code:
    create or replace PROCEDURE affich(NMCLI IN NUMBER , STARTDATE IN DATE , ENDATE IN DATE,c out sys_refcursor)IS
    BEGIN 
    OPEN C FOR
    SELECT   FO.NUMFOUR,
    	 FO.RAISONSOCIAL,
    	 F.NUMFACTURE,
             SUM(CAT.PRIX * PRF.QTE)
     from	 CATEGORIE CAT,
    	 PRODUITSFACTURE PRF,
    	 PRODUIT PR,
    	 FOURNISSEUR FO,
    	 FACTURE F
     where   CAT.NUMCAT=PR.NUMCAT
     and	 F.NUMFOUR=FO.NUMFOUR
     and	 PR.NUMEROPRODUIT=PRF.NUMEROPROD
     and	 PRF.NUMFACTURE=F.NUMFACTURE
    END;
    --------------------------------------------------------
    Errors list :
    Compilation failed,line 16 (17:38:03)
    PL/SQL: ORA-00933: SQL command not properly ended
    Compilation failed,line 4 (17:38:03)
    PL/SQL: SQL Statement ignored
    Compilation failed,line 17 (17:38:03)
    PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin case declare end exception exit for goto if loop mod null pragma raise return select update while with << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    you need to add a missing SEMI COLON in line 16.

    Comment

    Working...