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
Comment