|
|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ: 83569622 。
您需要 登录 才可以下载或查看,没有帐号?注册
x
代码如下:
DECLARE
RESULT NUMBER := NULL;
error1 po_api_errors_rec_type;
BEGIN
-- Do not forget to commit after the result returns 1
-- and rollback if result returns 0.
-- This needs to change as per your application.
dbms_application_info.set_client_info('103');
RESULT := po_change_api1_s.update_po(x_po_number => '100000005-2'
,x_release_number => null
,x_revision_number => 0
,x_line_number => 6
,x_shipment_number => 1
,new_quantity => 30
,new_price => 34.4
,new_promised_date => SYSDATE-1
,launch_approvals_flag => 'Y'
,update_source => NULL
,version => '2.0'
,x_override_date => SYSDATE
,x_api_errors => error1
,p_buyer_name => NULL);
dbms_output.put_line('result:' || RESULT);
IF (RESULT = 1) THEN
COMMIT;
dbms_output.put_line('Committed successfully');
ELSE
ROLLBACK;
dbms_output.put_line('Rollback occured');
END IF;
EXCEPTION
WHEN OTHERS THEN
RAISE;
END;
我要修改'100000005-2'订单的行6的数量、价格及promised_date 。 |
|