求助:请高手看看这个存储错误是怎么回事
我建立了一个导表得存储,错误提示如下,请问这是怎么回事,我查询了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 errors
SQL> 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