JUST WANT ONE INSERT STATEMENT AND SEVERAL SELECT STATEMENTS
Error when l run script
(SELECT
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-00936: missing expression
Insert into Step2 (
DEA386,BRN386,BRO386,SBR386,LOF386,INSTITUITION,AMOUNT,DID386
(SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,AH1386,DA1386,DID386),
(SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,AH2386,DA2386,DID386),
(SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,AH3386,DA3386,DID386),
(SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,AH4386,DA4386,DID386),
(SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,AH5386,DA5386,DID386),
(SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,AH6386,DA6386,DID386),
(SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,AH7386,DA7386,DID386),
(SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,AH8386,DA8386,DID386),
(SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,AH9386,DA9386,DID386),
(SELECT
DEA386,BRN386,BRO386,SBR386,LOF386,AH0386,DA0386,DID386
FROM STEP1
WHERE bro386 NOT IN ('SBSA','KIOSKS','HMC','CREDIT','ESP',
'PSA','AIN','HOSPERSA','REGIONAL',
'COVERHOLD','WACC','NATU','ACC CARE',
'TAF BROK','AB CC'
)
AND lof386 NOT IN ('153','1114','97',
'4843','4849','1157',
'E0080','J0196','15121' ));
COMMIT;
|