求助：请高手看看这个错误是怎么回事

Question

我建立了一个导表得存储，错误提示如下，请问这是怎么回事，我查询了insert也搞不懂错在哪里，dcdb是一个用户，而aaa是另外得一个用户，把aaa得字段导入到dcdb，怎么不行呢？create or replace procedure aaaforeigncurrency2T_CURRENCY(aaa_parameter in varchar2)
is
del_para1 varchar2(50);begin
delete from aaa.aaaforeigncurrency2T_CURRENCY where del_para1 = aaa_parameter
dbms_output.enable;insert into DCDB.t_account(DCDB.t_account.id, 
                           DCDB.t_account.stationid, 
                           DCDB.t_account.UA_ACCOUNT.cAcc_Id, 
                           DCDB.t_account.UA_ACCOUNT.cAcc_Name)
                    select(aaa.ua_account.muf_id,
                           aaa.ua_account.muf_stationid,
                           aaa.ua_account.muf_accountNo, 
                           aaa.ua_account.muf_accountName) 
                     from aaa.ua_account where del_para1 = aaa_parameter;
dbms_output.put_line('sucess');
exception
when no_data_found then 
dbms_output.put_line('nodata found');
end aaaforeigncurrency2T_CURRENCY;Warning: Procedure created with compilation errorsSQL> show err;
Errors for PROCEDURE aaa.aaaFOREIGNCURRENCY2T_CURRENCY:LINE/COL ERROR
-------- -------------------------------------
7/82     PL/SQL: ORA-00933: SQL 命令未正确结束
7/1      PL/SQL: SQL Statement ignored
14/50    PL/SQL: ORA-00907: 缺失右括号
10/1     PL/SQL: SQL Statement ignored

Answer 1

7/82     PL/SQL: ORA-00933: SQL 命令未正确结束 －－语句末尾缺分号"where del_para1 = aaa_parameter;" 这里面的 del_para1 是个字段名称？？

Answer 2

除了你提出的，还有select不能带括号，得去掉。