Home » SQL & PL/SQL » SQL & PL/SQL » Ora :907 missing right parenthesis
Ora :907 missing right parenthesis [message #19282] |
Fri, 08 March 2002 01:12 |
Rm69
Messages: 39 Registered: January 2002
|
Member |
|
|
Trying to use one insert statement with more than 2 select statements and group by dea386.
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 STEP2);
COMMIT;
|
|
|
Re: Ora :907 missing right parenthesis [message #19283 is a reply to message #19282] |
Fri, 08 March 2002 02:18 |
a
Messages: 22 Registered: March 2002
|
Junior Member |
|
|
try like this...
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 STEP2));
COMMIT;
|
|
|
Re: Ora :907 missing right parenthesis [message #19299 is a reply to message #19282] |
Sun, 10 March 2002 03:22 |
Rm69
Messages: 39 Registered: January 2002
|
Member |
|
|
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;
|
|
|
Goto Forum:
Current Time: Sun Jun 30 00:25:49 CDT 2024
|