在向oracle erp中增加一个用户. 按照提供的接口表,我将一条新客户的信息插入到ar.ra_customers_interface_all中了.下一步,如何在程序中(.net开发环境)递交客户接口数据,不是很清楚.请问高手们知道吗?查看了官方网站的资料,没有得到太多的信息.
请提供思路,有例子说明或文档更好!

写个PLSQL 包含 提交请求，然后 .net 调用PLSQL

在sql*plus中执行
declare
I_request_id number;
p_message varchar2(255);
begin
I_request_id:=apps.fnd_request.submit_request('AR','RACUST','','',FALSE,chr(0),'','','','','','','','','', '','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');
commit;
if (I_request_id>0)
then
p_message:='Request ID:'||to_char(I_request_id);
dbms_output.put_line('I_request_id:'||I_request_id||',');
dbms_output.put_line('p_message:'||p_message);
commit;
else
p_message:=apps.fnd_message.get;
dbms_output.put_line('I_request_id:'||I_request_id||',');
dbms_output.put_line('p_message:'||p_message);
rollback;
end if;
end;
结果:
I_request_id:0,
p_message:ORACLE error -2289 in SUBMIT: others

Cause:  SUBMIT: others failed
due to ORA-02289: 序列（号）不存在.

The SQL statement being executed at the
time of the error was: &SQLSTMT and was executed from the file &ERRFILE.

PL/SQL 过程已成功完成。

我分别在ar.ra_customers_interface_all和ar.ra_customer_profiles_int_all中插入数据.
其中前者表中,插入必须字段:
insert into ar.ra_customers_interface_all(orig_system_customer_ref,insert_update_flag,customer_name,customer_status,customer_number,last_updated_by,last_update_date,created_by,creation_date) "
                                        + "values('cust0001','I','c test','A',9000,-1,sysdate,-1,sysdate)

后者插入了
insert into ar.ra_customer_profiles_int_all(insert_update_flag,orig_system_customer_ref,customer_profile_class_name,"
                                        +"credit_hold,last_updated_by,last_update_date,creation_date,created_by) "
                                        +"values('I','cust0001','DEFAULT','N','-1',sysdate,sysdate,'-1')

怎么没有人帮忙回答呀?

你的问题解决了吗,我也有同样的问题,交流一下

先在PL/SQL中把程序调试通过，然后采用上面的思路来进行调用，从LZ提供的信息来看，应该是PL/SQL都没通过的