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 Go to next message
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;

Report message to a moderator

Re: Ora :907 missing right parenthesis [message #19283 is a reply to message #19282] Fri, 08 March 2002 02:18 Go to previous messageGo to next message
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;

Report message to a moderator

Re: Ora :907 missing right parenthesis [message #19299 is a reply to message #19282] Sun, 10 March 2002 03:22 Go to previous message
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;

Report message to a moderator

Previous Topic: Problem with Long datatype
Next Topic: Updating an Oracle Database from another.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 22:23:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.