Expand|Select|Wrap|Line Numbers
- 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