Here is a PL/SQL package that I’ve made to check and convert Belgian’s BBANs and IBANs codes whitin SQL queries.
package : BBAN_IBAN_BIC.sql (159)
package body : BBAN_IBAN_BIC_Body.sql (156)
You’ll need a table of BICs codes to get the BIC code out of BBAN and IBAN.
Download an updated version from :
http://www.bnb.be/ « Systèmes de paiement »> »Standards de paiements »> »Codes d’identification des banques »
or you could use directly this one (at youre own risk) : BIC_Table.sql (247)