Sunday, December 29, 2013
In this post, I tried to give a sample execution script for the private API CE_BANK_AND_ACCOUNT_VALIDATION.VALIDATE_IBAN
It can be used to validate whether the given bank account number is an IBAN number or not. It was very helpful for us in the current project. Hence, thought to share.
SET SERVEROUTPUT ON:
lv_iban_out VARCHAR2 (200);
lv_return_status VARCHAR2 (200);
p_account_no VARCHAR2 (35) DEFAULT 'FI1234567890123';
(p_iban => p_account_no,
p_iban_out => lv_iban_out,
x_return_status => lv_return_status
IF lv_return_status = 'S'
DBMS_OUTPUT.put_line ('Bank Account Type : IBAN');
DBMS_OUTPUT.put_line ('Bank Account is not a IBAN number');
DBMS_OUTPUT.put_line ('Error : ' || SQLERRM);
Do you think this Article is useful?
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.