CREATE TABLE "SYSTEM"."ID_DOWNLOADS" 
(   "LOADID" NUMBER NOT NULL ENABLE, 
    "DATELOAD" DATE NOT NULL ENABLE, 
    CONSTRAINT "ID_DOWNLOADS_PK" PRIMARY KEY ("LOADID")
);

CREATE TABLE "SYSTEM"."CAR_BRAND" 
(   "CARBRANDID" NUMBER NOT NULL ENABLE, 
    "BRANDNAME" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
    CONSTRAINT "CAR_BRAND_PK" PRIMARY KEY ("CARBRANDID")
);

CREATE TABLE "SYSTEM"."SALECAR" 
(   "CARBRANDID" NUMBER NOT NULL ENABLE, 
    "CARMODELID" NUMBER NOT NULL ENABLE, 
    "COSTT" NUMBER NOT NULL ENABLE, 
    "SALEDATE" DATE NOT NULL ENABLE, 
    "LOADID" NUMBER
);

SET SERVEROUTPUT ON
CREATE OR REPLACE Procedure SummSale ( date_in IN date )
  IS
 no_loadid1 EXCEPTION;
 Loadid1 number;
 TYPE SummSale IS RECORD (
    Brandname   VARCHAR2(30),
    Costt  NUMBER (20)
   );
   summ_sale SummSale;
 begin
 SELECT loadid INTO loadid1 from id_downloads where dateload = date_in;
 IF loadid1 = NULL THEN
    RAISE no_loadid1;
 ELSE
   DBMS_OUTPUT.PUT_LINE(loadid1);
   SELECT Br.BRANDNAME, SUM(Sc.COSTT) AS COSTT INTO Summ_Sale.Brandname, Summ_Sale.Costt 
   FROM CAR_BRAND Br INNER JOIN SALECAR Sc ON Br.CARBRANDID = Sc.CARMODELID 
   WHERE (((loadid1) = Sc.loadid)) GROUP BY Br.Brandname; 
   DBMS_OUTPUT.PUT_LINE('Brandname:   ' || Summ_Sale.Brandname);
   DBMS_OUTPUT.PUT_LINE('Cost:   ' || Summ_Sale.Costt);
 END if;
 exception
 WHEN no_loadid1 THEN
 raise_application_error (-20001,'load id not found in order to submit.');
 END SummSale;
 /
show errors
 declare
 date1 date;
 begin
 date1:=28/01/2018;
 SummSale(date1); 
 end;