gET AN ERROR WHEN I RUN TWO PROCEDURES IN ONE WHY ?oR MAYBE L SHOULD USE A CURSOR INSTEAD OF THE SELECT STATEMENTS?iF I
USE A CURSOR WHERE IN THE PROCEDURE WILL IT BE?
aNY IDEAS
PLS-00103: Encountered the symbol "PROCEDURE"
-- STEP_1
CREATE OR REPLACE PROCEDURE INS_MIS_DATA
(V_START_DATE DATE,V_END_DATE DATE)
IS
BEGIN
INSERT INTO STEP
(
DEA386,BRN386,BRO386,SBR386,LOF386,CAP386,AH1386,DA1386,
AH2386,DA2386,AH3386,DA3386,AH4386,DA4386,AH5386,DA5386,
AH6386,DA6386,AH7386,DA7386,AH8386,DA8386,AH9386,DA9386,
AH0386,DA0386,DID386
)
SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,CAP386,AH1386,DA1386,
AH2386,DA2386,AH3386,DA3386,AH4386,DA4386,AH5386,DA5386,
AH6386,DA6386,AH7386,DA7386,AH8386,DA8386,AH9386,DA9386,
AH0386,DA0386,DID386
FROM PW38600P
WHERE AH1386 LIKE '%AFRICAN BANK%' AND
(AH2386 LIKE '%AFRICAN BANK%' OR
AH3386 LIKE '%AFRICAN BANK%' OR
AH4386 LIKE '%AFRICAN BANK%' OR
AH5386 LIKE '%AFRICAN BANK%' OR
AH6386 LIKE '%AFRICAN BANK%' OR
AH7386 LIKE '%AFRICAN BANK%' OR
AH8386 LIKE '%AFRICAN BANK%' OR
AH9386 LIKE '%AFRICAN BANK%' OR
AH0386 LIKE '%AFRICAN BANK%')
;
COMMIT;
END;
PROCEDURE INSERT_DATA
IS
BEGIN
-- 1
INSERT INTO STEP3(
DEAL,BRN,BRO,SBR,LOF,CAPITAL,INSTITUITION,AMOUNT,PDINCL,DID)
SELECT DEA386,BRN386,BRO386,CAP386,AH1386,AD1386,(CAP386*1.4),DID386
FROM STEP;
COMMIT;
--2
INSERT INTO STEP3(
DEAL,BRN,BRO,SBR,LOF,CAPITAL,INSTITUITION,AMOUNT,PDINCL,DID)
SELECT DEA386,BRN386,BRO386,CAP386,AH2386,AD2386,(CAP386*1.4),DID386
FROM STEP;
COMMIT;
--3
INSERT INTO STEP3(
DEAL,BRN,BRO,SBR,LOF,CAPITAL,INSTITUITION,AMOUNT,PDINCL,DID)
SELECT DEA386,BRN386,BRO386,CAP386,AH3386,AD3386,(CAP386*1.4),DID386
FROM STEP;
COMMIT;
--4
INSERT INTO STEP3(
DEAL,BRN,BRO,SBR,LOF,CAPITAL,INSTITUITION,AMOUNT,PDINCL,DID)
SELECT DEA386,BRN386,BRO386,CAP386,AH4386,AD4386,(CAP386*1.4),DID386
FROM STEP;
COMMIT;
--5
INSERT INTO STEP3(
DEAL,BRN,BRO,SBR,LOF,CAPITAL,INSTITUITION,AMOUNT,PDINCL,DID)
SELECT DEA386,BRN386,BRO386,CAP386,AH5386,AD5386,(CAP386*1.4),DID386
FROM STEP;
COMMIT;
--6
INSERT INTO STEP3(
DEAL,BRN,BRO,SBR,LOF,CAPITAL,INSTITUITION,AMOUNT,PDINCL,DID)
SELECT DEA386,BRN386,BRO386,CAP386,AH6386,AD6386,(CAP386*1.4),DID386
FROM STEP;
COMMIT;
--7
INSERT INTO STEP3(
DEAL,BRN,BRO,SBR,LOF,CAPITAL,INSTITUITION,AMOUNT,PDINCL,DID)
SELECT DEA386,BRN386,BRO386,CAP386,AH7386,AD7386,(CAP386*1.4),DID386
FROM STEP;
COMMIT;
--8
INSERT INTO STEP3(
DEAL,BRN,BRO,SBR,LOF,CAPITAL,INSTITUITION,AMOUNT,PDINCL,DID)
SELECT DEA386,BRN386,BRO386,CAP386,AH8386,AD8386,(CAP386*1.4),DID386
FROM STEP;
COMMIT;
--9
INSERT INTO STEP3(
DEAL,BRN,BRO,SBR,LOF,CAPITAL,INSTITUITION,AMOUNT,PDINCL,DID)
SELECT DEA386,BRN386,BRO386,CAP386,AH9386,AD9386,(CAP386*1.4),DID386
FROM STEP;
COMMIT;
--10
INSERT INTO STEP3(
DEAL,BRN,BRO,SBR,LOF,CAPITAL,INSTITUITION,AMOUNT,PDINCL,DID)
SELECT DEA386,BRN386,BRO386,CAP386,AH0386,AD0386,(CAP386*1.4),DID386
FROM STEP;
COMMIT;
END;
|